Re: to_timestamp error handling.

From: Dhaval Jaiswal <dhaval(dot)jaiswal(at)enterprisedb(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: to_timestamp error handling.
Date: 2009-06-10 14:23:46
Message-ID: c5a53f7b0906100723s7da73249v82140e152eef9ce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2009-06-10 14:29:55 Re: to_timestamp error handling.
Previous Message Tom Lane 2009-06-10 14:05:36 Re: Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking