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

From Ken Benson
Subject Re: Import CSV with Dates & Times
Date
Msg-id 4FA3DCD7.1040803@infowerks.com
Whole thread Raw
In response to Re: Import CSV with Dates & Times  (James David Smith <james.david.smith@gmail.com>)
List pgsql-novice
Have you considered this:
to_timestamp('201024June10:12am', 'YYYYDDFMMonthHH12:MIam')

The 'to_timestamp' function - allows for a format string.

On 5/4/2012 6:38 AM, James David Smith wrote:
Just to report that I've realised what the problem was. PostgreSQL was
expecting the data in an american format of MM/DD/YYYY rather than the
UK version which is DD/MM/YYYY .



On 4 May 2012 13:31, James David Smith <james.david.smith@gmail.com> wrote:
Simon,

Thanks for this. I don' t have pgloader installed and a quick search
seems to suggest it's a Linux tool? I'm working in Windows
unfortunately. Maybe a bit more info would be good...

Here is my table:

create table ibus_17_11_2011(
route INTEGER,
scheduled_depart_time TIMESTAMP
)

Here is my copy command:

COPY ibus_17_11_2011 from 'C:/Program Files
(x86)/PostgreSQL/8.4/data/ibus_17_11_2011_v2.csv' DELIMITERS ',' CSV;

My date looks like this:

2  ,  17/11/2011 17:08:35
3  ,  17/11/2011 17:08:56

Thanks

James



On 4 May 2012 12:47, Simon Riggs <simon@2ndquadrant.com> wrote:
On 4 May 2012 12:38, James David Smith <james.david.smith@gmail.com> wrote:

Any sugestions please?
Use pgloader

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-novice by date:

Previous
From: James David Smith
Date:
Subject: Re: Import CSV with Dates & Times
Next
From: Tom Lane
Date:
Subject: Re: Import CSV with Dates & Times