Specifying date locales - Mailing list pgsql-general

From Andrew.Mason@spektra.co.uk
Subject Specifying date locales
Date
Msg-id OF942CFBF2.CE2A6915-ON80256960.002837BF@spektra.co.uk
Whole thread Raw
List pgsql-general
I have a timestamp field, into which I will be inserting UK style dates
i.e. 31/3/2000.
If I insert an ambiguous date i.e. 11/1/2000  postgresql seems to assume
that it is in US format.
How can I specify that the date will always be in UK format?

Andrew Mason


pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: nasty problem with redhat 6.2 + pg 7.02
Next
From: Andreas Tille
Date:
Subject: Re: pgdump