Re: Dates
От | Bob Pawley |
---|---|
Тема | Re: Dates |
Дата | |
Msg-id | 007801c61c5b$75fceef0$ac1d4318@owner обсуждение исходный текст |
Ответ на | Dates (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Dates
|
Список | pgsql-general |
Perhaps you have a solution?? Bob ----- Original Message ----- From: "Scott Marlowe" <smarlowe@g2switchworks.com> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Postgresql" <pgsql-general@postgresql.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
В списке pgsql-general по дате отправления: