Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Import CSV with Dates & Times
Date
Msg-id 3905.1336139724@sss.pgh.pa.us
Whole thread Raw
In response to Import CSV with Dates & Times  (James David Smith <james.david.smith@gmail.com>)
List pgsql-novice
Tree view 
James David Smith <james.david.smith@gmail.com> writes:
> 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?

As the hint suggests, you probably need to adjust the datestyle setting
(to "dmy", looks like).

            regards, tom lane

pgsql-novice by date:

Previous
From: Ken Benson
Date:
Subject: Re: Import CSV with Dates & Times
Next
From: DrYSG
Date:
Subject: WHERE clause with 40+ conditions