Re: date format

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: date format
Date: 2007-03-05 06:14:32
Message-ID: 45EBB548.5090502@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Garry Saddington schrieb:
> I have 'datestyle ISO,DMY' set in postgresql.conf but the date output is still
> rendered in the format (y,m,d) . How can I change this behaviour?
> regards
> garry
>
See my answer on the Zope list. The style however influences the way
dates are parsed by default, so you need to take care when you
feed dates from your application to database.
You should also use to_date() to make it explicit.

Regards
Tino

In response to

  • date format at 2007-03-04 12:47:05 from Garry Saddington

Browse pgsql-general by date

  From Date Subject
Next Message Naz Gassiep 2007-03-05 07:38:13 Re: Query timing
Previous Message A. Kretschmer 2007-03-05 06:00:36 Re: Query timing