Re: to_timestamp error handling.

On Wed, Jun 10, 2009 at 3:23 PM, Dhaval
Jaiswal<dhaval.jaiswal@enterprisedb.com> wrote:
>
> postgres=3D# select to_timestamp('20096010','YYYYMMDD');
>
> =A0=A0=A0=A0=A0=A0 to_timestamp
> ---------------------------
> =A02013-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.

--=20
Gregory Stark
http://mit.edu/~gsstark/resume.pdf