importing DB2 timestamp?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: importing DB2 timestamp?
Date: 2002-11-25 23:32:41
Message-ID: OFF6E3F12D.F12F1D4B-ON88256C7C.007F3E8D-88256C7C.0081739E@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Brusowankin 2002-11-26 02:28:29 How do I write a script that .....
Previous Message Bruno Wolff III 2002-11-25 19:34:16 Re: arrays vs. columns