Re: date format - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: date format
Date
Msg-id 45EBB548.5090502@wildenhain.de
Whole thread Raw
In response to date format  (Garry Saddington <garry@schoolteachers.co.uk>)
List 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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Query timing
Next
From: Naz Gassiep
Date:
Subject: Re: Query timing