Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date - Mailing list pgsql-sql

>>
>> 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!