Postgres Pro
Downloads
Home   >   mailing lists

Thread: importing DB2 timestamp?

importing DB2 timestamp?

From
"Patrick Hatcher"
Date:
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

Re: importing DB2 timestamp?

From
Tom Lane
Date:
"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

Re: importing DB2 timestamp?

From
"Patrick Hatcher"
Date:
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