Re: to_date conversion semantics?

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: to_date conversion semantics?
Дата
Msg-id
4C97B58E.9080204@archonet.com
Ответ на
Список
Дерево обсуждения
to_date conversion semantics? "Colin 't Hart" <colinthart@gmail.com>
Re: to_date conversion semantics? Adrian Klaver <adrian.klaver@gmail.com>
Re: to_date conversion semantics? "Colin 't Hart" <colinthart@gmail.com>
Re: to_date conversion semantics? Adrian Klaver <adrian.klaver@gmail.com>
Re: to_date conversion semantics? "Colin 't Hart" <colinthart@gmail.com>
Re: to_date conversion semantics? Tom Lane <tgl@sss.pgh.pa.us>
Re: to_date conversion semantics? Richard Huxton <dev@archonet.com>
On 20/09/10 20:18, Colin 't Hart wrote:
> The 32nd of Undecember (!) turning into the 1st of February of the
> next year... instead of throwing an exception like I expect.

What Tom said, but it's presumably using mktime(...) somewhere internally.

perl -MPOSIX  -e 'print scalar gmtime(mktime(0,0,0,32,13-1,73)),"\n"'
Fri Feb  1 00:00:00 1974

http://perldoc.perl.org/POSIX.html#mktime
http://linux.die.net/man/3/mktime

-- 
   Richard Huxton
   Archonet Ltd
В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: Dmitriy Igrishin
Дата:
FAQ