Re: How to get day of week?

The function you're looking for is to_char(), and it has tons of options.

http://www.postgresql.org/docs/7.4/static/functions-formatting.html

Jeff

Lloyd Dieter wrote:

>I'm sure I'm missing something obvious, but this is the novice list, so
>here goes:
>
>Is there a function to return the day-of-week for a given time/datestamp?
>
>What I'm looking for is something like:
>
>select day(current_timestamp);
>
>That would return the current day of the week (e.g. Monday/Tuesday...)
>
>Thanks,
>
>-Lloyd
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>