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
This is exactly what I am looking for. > select to_char(current_date,'Day'); > select to_char(current_date,'D'); 1: Sunday 2: Monday 3: Tuesday 4: Wednesday 5: Thursday 6: Friday 7: Saturday Thank you very much for all your inputs! -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
