Re: output format for dates

am@fx.ro dijo:

Hi,

> I would like to use the following format for dates:
> DD-MON-YYYY or DD-MON-YY, where MON is one of : JAN,FEB,..,DEC.
> (for example 20-APR-2002) for both input and output.

You can use to_char(),

regression=# select (to_char('20-04-2002'::date, 'dd-MON-yyyy'));
   to_char
-------------
 20-APR-2002
(1 row)

regression=#

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Y eso te lo doy firmado con mis lagrimas" (Fiebre del loco)