that was it. thank you!
Patrick Hatcher
Macys.Com
Tom Lane
<tgl@sss.pgh.pa.us> To: "Patrick Hatcher" <PHatcher@macys.com>
Sent by: cc: pgsql-novice@postgresql.org
pgsql-novice-owner@post Subject: Re: [NOVICE] importing DB2 timestamp?
gresql.org
11/25/2002 07:23 PM
"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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly