Postgres Pro
Downloads
Home   >   mailing lists

Re: importing DB2 timestamp? - Mailing list pgsql-novice

From Tom Lane
Subject Re: importing DB2 timestamp?
Date
Msg-id 5114.1038280983@sss.pgh.pa.us
Whole thread Raw
In response to importing DB2 timestamp?  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-novice
Tree view 
"Patrick Hatcher" <PHatcher@macys.com> writes:
> I'm receiving a flat file dump from a DB2 feed.  In this file, I have a
> number of timestamp fields that appear as such:
> 2002-10-30-19.00.05.224939. Pg doesn't seem to recognize this as a valid
> timestamp.  I've tried converting the timestamp to   2002-10-30-19
> 00:05:224939  and 2002-10-30-19 00:05:22, but it still won't import.

I would think you want '2002-10-30 19:00:05.224939'.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: importing DB2 timestamp?
Next
From: "paul butler"
Date:
Subject: Re: Tools: schema designer; scripts