Re: Import CSV with Dates & Times

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James David Smith <james(dot)david(dot)smith(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Import CSV with Dates & Times
Date: 2012-05-04 13:55:24
Message-ID: 3905.1336139724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

James David Smith <james(dot)david(dot)smith(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message DrYSG 2012-05-04 18:31:51 WHERE clause with 40+ conditions
Previous Message Ken Benson 2012-05-04 13:42:47 Re: Import CSV with Dates & Times