On Thu, Aug 23, 2012 at 3:42 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Magnus Hagander <mag...@hagander.net> writes: >> postgres=# select to_timestamp('2012-08-01', 'yyyy-mm-dd'); >> to_timestamp >> ------------------------ >> 2012-08-01 00:00:00+02 > >> postgres=# select to_timestamp('2012-08-00', 'yyyy-mm-dd'); >> to_timestamp >> ------------------------ >> 2012-08-01 00:00:00+02 > >> postgres=# select to_timestamp('2012-00-00', 'yyyy-mm-dd'); >> to_timestamp >> ------------------------ >> 2012-01-01 00:00:00+01 > >> Should we really convert 00 to 01? > > to_timestamp is intentionally pretty loose. Personally, if I wanted > sanity checking on a date string in any common format, I would just > cast the string to timestamp(tz), and *not* use to_timestamp.
Shouldn't we put at least a note, and IMO even a *warning* in the docs saying that it is like this? (or am I missing one we have) It's not really consistent with how most of postgres works :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers