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/