Re: Dates - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Dates
Date
Msg-id 1137607395.25500.69.camel@state.g2switchworks.com
Whole thread Raw
In response to Dates  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
> Hi Folks
>
> I have a column for date which defaults to the ambigous 2005-1-1
> format.
>
> The documantation indicates how to change this to the unambigous Jan 1
> 2005, but the instructions aren't clear to me.

Actually, if the year comes first, it is not ambiguous.  It will always
be month-day if the year comes first.  It's the

mm/dd/yyyy or dd/mm/yyyy that is the issue.

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Dates
Next
From: Scott Marlowe
Date:
Subject: Re: latest HISTORY file