date/time field value out of range

Поиск
Список
Период
Сортировка
От Samuele Brignoli
Тема date/time field value out of range
Дата
Msg-id 40B7062A.1070904@darpha.com
обсуждение исходный текст
Список pgsql-general
Hi,
I've upgarded my redhat 7.3 Linux box to Postgresql 7.3.4 but now some
of my application managing timestamps fields fail on insert.

I' ve tried setting the locale, the date style variable without results.
I'm lost .

    Can you hel me ?

    Bye, Samu.

-----------------

Error while executing the query; ERROR: date/time field value out of
range: "28-05-2004 11:11:59"


insert into

kleweshp_pror(prcod_id,prdatord,prcodcli,prcodage,prcodlis,prcodval,prscocl1,prscocl2,prcodart,prqtaord,prprezzo,prdateva,prscont1,prscont2,prscont3,prscont4,prcoddes,prconprg,prflgcon,prstaord)

values (1,'28-05-2004
11:11:59','14100001','','00001','EUR',0.00,0.00,'F11012700 ',1.000,
36.42000,null,-40.00,-15.00,0.00,0.00,'001 ','','','P')


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

Предыдущее
От: "Hale"
Дата:
Сообщение: Connecting to an External DB (repost)
Следующее
От: john_ramsden@sagitta-ps.com (John Ramsden)
Дата:
Сообщение: What does error code PGSQL_TUPLES_OK (2) actually mean?