On 11/5/2013 1:04 AM, bsreejithin wrote:
A wrong date like ,say, 33-Oct-2013 gets converted as 2-Nov-2013 when the
data is loaded into a date field. No error raised.Data gets uploaded!
ummmmm. postgresql won't do that conversion
postgres=# select '33-Oct-2013'::date;
ERROR: date/time field value out of range: "33-Oct-2013"
LINE 1: select '33-Oct-2013'::date;
^
.
how exactly are you inserting this CSV data into postgres ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
