Hi,
I have a problem importing some data. I have created a table with a
column which is called scheduled_depart_time and has the data type
'TIMESTAMP'. When I try to import data from a CSV the data in that
column has values such as '17/11/2011 16:54:03'. I get an error of the
below:
ERROR: date/time field value out of range: "17/11/2011 15:17:00"
HINT: Perhaps you need a different "datestyle" setting.
CONTEXT: COPY ibus_17_11_2011, line 1, column scheduled_depart_time:
"17/11/2011 15:17:00"
Any sugestions please?
Thanks
James