| From: | bsreejithin <bsreejithin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Junk date getting uploaded into date field |
| Date: | 2013-11-05 12:46:54 |
| Message-ID: | 1383655614614-5776992.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2013-11-05 12:50:50 | Re: Junk date getting uploaded into date field |
| Previous Message | Thomas Kellerer | 2013-11-05 12:36:00 | Re: Junk date getting uploaded into date field |