On Wed, Jun 10, 2009 at 3:23 PM, Dhaval
Jaiswal<dhaval(dot)jaiswal(at)enterprisedb(dot)com> wrote:
>
> postgres=# select to_timestamp('20096010','YYYYMMDD');
>
> to_timestamp
> ---------------------------
> 2013-12-18 00:00:00+05:30
>
> (1 row)
>
> The month is 60 in my case and it is giving some random value, whereas I am
> expecting some error message like date is not valid.
I suspect you'll find that the 60th month after the start of 2009 is
in fact december 2013.
--
Gregory Stark
http://mit.edu/~gsstark/resume.pdf