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