Re: to_date conversion semantics? - Mailing list pgsql-general

From Richard Huxton
Subject Re: to_date conversion semantics?
Date
Msg-id 4C97B58E.9080204@archonet.com
Whole thread Raw
In response to Re: to_date conversion semantics?  ("Colin 't Hart" <colinthart@gmail.com>)
List pgsql-general
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: to_date conversion semantics?
Next
From: Dmitriy Igrishin
Date:
Subject: Re: INSERT with SELECT not working in pgAdmin