Re: [ADMIN] Datetypes - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: [ADMIN] Datetypes
Date
Msg-id 200001121442.JAA29068@candle.pha.pa.us
Whole thread Raw
In response to Datetypes  ("Strand Johan F." <johan.f.strand@telia.se>)
List pgsql-admin
[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

pgsql-admin by date:

Previous
From: Mattias Norlander
Date:
Subject: Re: [ADMIN] Datetypes
Next
From: Cory Kempf
Date:
Subject: Re: postgresql installation