Howdy,
I'm trying to import data from an external database that has the date
formatted as such: 2002-05-20 00.00.01. When I try to import the data, I
get the Bad Timestamp external representation error. I would usually
remove the time section, but for this particular table I need down to the
second. Could someone point me in the right direction?
TIA
CREATE TABLE "xmlpricetest" (
"upc" int8 NOT NULL,
"unit_price" float8,
"compare_price" float8,
"price_value" float8,
"price_indicator" int2,
"start_date" timestamp,
"end_date" timestamp
) WITH OIDS;
Patrick Hatcher
Macys.Com