[SQL] Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date

[Emi Lu]

Good morning,

Could someone tell me the command to get the weekly day name and day 
number please.


I am expecting something like:

sql> select data_part('day name', current_date);
sql> Monday

sql> select data_part('day number', current_date);
sql> 1

(Mon =1 ... Sun =7?)

Thanks a lot!

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql