Import CSV with Dates & Times

Поиск
Список
Период
Сортировка
От James David Smith
Тема Import CSV with Dates & Times
Дата
Msg-id CAMu32ACFQdub1O7DjcdtO4Z-HPk+hvj=vTt+fbsp6c7T8NyR1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Import CSV with Dates & Times  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Import CSV with Dates & Times  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Marta Pérez Romero
Дата:
Сообщение: Re: Query to get the min of the total
Следующее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: Query to get the min of the total