From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dates |
Date: | 2006-01-18 18:17:37 |
Message-ID: | 007801c61c5b$75fceef0$ac1d4318@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Perhaps you have a solution??
Bob
----- Original Message -----
From: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 18, 2006 10:03 AM
Subject: Re: [GENERAL] Dates
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-01-18 18:22:17 | Re: Dates |
Previous Message | Scott Marlowe | 2006-01-18 18:11:38 | Re: latest HISTORY file |