> in 7.0:
>
> to_char(now(), 'DAY') for MONDAY
> to_char(now(), 'Day') for Monday
> to_char(now(), 'day') for monday
>
> ... but all is in English, and as said Peter it isn't SQL92 like
> (but Oracle compatible)
>
> (Any support for a locale output is plan for far far far future....)
The upper/lower case thing is totally cool.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026