Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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- 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?

Patrick Hatcher


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group