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