COPY returns Bad timestamp external rep.. - Mailing list pgsql-novice

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