Re: [despammed] How to get day of week? - Mailing list pgsql-novice

On Tue, Dec 21, 2004 at 01:42:17PM +0100, Andreas Kretschmer wrote:
>
> select extract(dow from eingang) from a_buch ;

See also to_char() in the "Data Type Formatting Functions" section
of the "Functions and Operators" chapter in the documentation.

SELECT to_char(CURRENT_DATE, 'D,Dy,Day');
    to_char
-----------------
 3,Tue,Tuesday

Note that to_char() and extract() use different numbering for the
day of the week.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/