Re: importing DB2 timestamp?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: importing DB2 timestamp?
Date: 2002-11-26 03:23:03
Message-ID: 5114.1038280983@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message srihari 2002-11-26 07:08:11 access to postgres from Kylix
Previous Message David Brusowankin 2002-11-26 02:28:29 How do I write a script that .....