Postgres Pro
Downloads
Home   >   mailing lists

Re: to_timestamp error handling. - Mailing list pgsql-bugs

From Dhaval Jaiswal
Subject Re: to_timestamp error handling.
Date
Msg-id c5a53f7b0906100723s7da73249v82140e152eef9ce@mail.gmail.com
Whole thread Raw
Responses Re: to_timestamp error handling.
Re: to_timestamp error handling.
List pgsql-bugs
Tree view 
Hi All,



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.



Is it an expected behaviour?


--
Thanks & Regards,
Dhaval Jaiswal
EnterpriseDB
Contact: 732-331-1300 Ext- 2022
+91-20-30589 516 / 494
web: www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking
Next
From: Greg Stark
Date:
Subject: Re: to_timestamp error handling.