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: OFF6E3F12D.F12F1D4B-ON88256C7C.007F3E8D-88256C7C.0081739E@fds.com (view raw or flat)
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-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





Responses

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-2014 The PostgreSQL Global Development Group