Postgres Pro
Downloads
Home   >   mailing lists

importing DB2 timestamp? - Mailing list pgsql-novice

From Patrick Hatcher
Subject importing DB2 timestamp?
Date
Msg-id OFF6E3F12D.F12F1D4B-ON88256C7C.007F3E8D-88256C7C.0081739E@fds.com
Whole thread Raw
Responses Re: importing DB2 timestamp?
List pgsql-novice
Tree view 
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.
Any clues what I've done wrong?
TIA
Patrick

Patrick Hatcher
Macys.Com

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: arrays vs. columns
Next
From: Tom Lane
Date:
Subject: Re: importing DB2 timestamp?