Re: Dates

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dates
Date: 2006-01-18 18:03:15
Message-ID: 1137607395.25500.69.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • Dates at 2006-01-18 18:00:34 from Bob Pawley

Responses

  • Re: Dates at 2006-01-18 18:17:37 from Bob Pawley

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-01-18 18:07:02 Re: latest HISTORY file
Previous Message Bob Pawley 2006-01-18 18:00:34 Dates