Re: [ADMIN] Datetypes

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hello there !
>
> How do I do if I want to change the variable
> DATETYPES or PGDATESTYLE to ISO.
> I want to se my date column like this 2000-01-12
> and not 01-12-2000 when I do a select on it.

SET DATESTYLE TO 'ISO'  should do it.  See my book for a section on date
styles in the web documentation page.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026