Date not being parsed as expected

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема Date not being parsed as expected
Дата
Msg-id 3D785827.8010805@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: Date not being parsed as expected  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Date not being parsed as expected  (Mario Weilguni <mweilguni@sime.com>)
Список pgsql-general
The following insert:

insert into t values('01-10-29')

gives the following result in the DB:

select * from t
      d
------------
  2029-01-10

Why is the first part (01) being parsed as the month? The DateStyle is
set to ISO (the default) so shoudln't the parser see xx-yy-zz as being
year-month-day?

Thanks,

Jc


В списке pgsql-general по дате отправления:

Предыдущее
От: frbn
Дата:
Сообщение: Re: installation
Следующее
От: Christoph Dalitz
Дата:
Сообщение: Re: Issues on OSX - Jaguar