Re: importing DB2 timestamp?

that was it. thank you!

Patrick Hatcher
Macys.Com

Tom Lane
<tgl(at)sss(dot)pgh(dot)pa(dot)us> To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Sent by: cc: pgsql-novice(at)postgresql(dot)org
pgsql-novice-owner(at)post Subject: Re: [NOVICE] importing DB2 timestamp?
gresql.org


11/25/2002 07:23 PM

"Patrick Hatcher" <PHatcher(at)macys(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly