Magnus Hagander <magnus@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.
regards, tom lane
