Specifying date locales

From: Andrew(dot)Mason(at)spektra(dot)co(dot)uk
To: pgsql-general(at)postgresql(dot)org
Subject: Specifying date locales
Date: 2000-09-20 07:31:15
Message-ID: OF942CFBF2.CE2A6915-ON80256960.002837BF@spektra.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Zeljko Trogrlic 2000-09-20 08:56:52 RE: Latest JDBC Driver? Where?
Previous Message Thomas Lockhart 2000-09-20 05:40:02 Re: nasty problem with redhat 6.2 + pg 7.02