Re: Junk date getting uploaded into date field - Mailing list pgsql-general

From bsreejithin
Subject Re: Junk date getting uploaded into date field
Date
Msg-id 1383655614614-5776992.post@n5.nabble.com
Whole thread Raw
In response to Re: Junk date getting uploaded into date field  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Junk date getting uploaded into date field
Re: Junk date getting uploaded into date field
List pgsql-general
I am not using any mail client.I was directly trying to post the content I
attached.Got a connection reset by peer error on submit.Thought some issue
with the browser - so tried with firefox, chrome as well, in addition to IE
- got the same error there also. Any way, that's not the issue.

I am not sure why : select to_date('33-OCT-2013', 'dd-mon-yyyy')

is returning 2013-11-02.

For cases like the issue I am facing, where we need to raise an error saying
the data is wrong, DB manipulating the data is not proper.

May be there could be some uses cases for such data manipulation. But then,
in that case, it would have been better to have a parameter which can switch
ON/OFF this behavior.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Junk-date-getting-uploaded-into-date-field-tp5776969p5776992.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Junk date getting uploaded into date field
Next
From: Edson Richter
Date:
Subject: Re: Junk date getting uploaded into date field