COPY returns Bad timestamp external rep..

Поиск
Список
Период
Сортировка
От Patrick Hatcher
Тема COPY returns Bad timestamp external rep..
Дата
Msg-id OFFB1D1F16.18470F07-ON88256BC2.007B1CC9@fds.com
обсуждение исходный текст
Ответы Re: COPY returns Bad timestamp external rep..
Список 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



В списке pgsql-novice по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: query problem - get count in related table
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: COPY returns Bad timestamp external rep..