Re: to_date conversion semantics?

Richard Huxton <dev@archonet.com>

From: Richard Huxton <dev@archonet.com>
To: pgsql-general@postgresql.org
Date: 2010-09-20T19:27:10Z
Lists: 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