am(at)fx(dot)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)