Emi Lu wrote:
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!
http://www.postgresql.org/docs/current/static/functions-formatting.html
select to_char(current_date,'Day');
select to_char(current_date,'D');
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
