Postgres Pro
Downloads
Home   >   mailing lists

Import CSV with Dates & Times - Mailing list pgsql-novice

From James David Smith
Subject Import CSV with Dates & Times
Date
Msg-id CAMu32ACFQdub1O7DjcdtO4Z-HPk+hvj=vTt+fbsp6c7T8NyR1g@mail.gmail.com
Whole thread Raw
Responses Re: Import CSV with Dates & Times
Re: Import CSV with Dates & Times
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Marta Pérez Romero
Date:
Subject: Re: Query to get the min of the total
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Query to get the min of the total