How can I get the day of the week for a given date in PostgreSQL?

Question

I want to retrieve day of the week from the given date.

For example the date is: 2015-01-28 then it has to return Wednesday

My bad try:

select date_part('week',now()) as weekday;

The above script gives me only number of week but not the day of the week.

Check to_char(): http://www.postgresql.org/docs/current/interactive/functions-formatting.html — Frank Heikens, Jan 28 '15 at 06:29

score 13 · Accepted Answer · answered Jan 28 '15 at 06:29

13

select to_char(now(), 'Day')

answered Jan 28 '15 at 06:29

Andomar