ERROR: date/time field value out of range: "28/05/2004 02:15:57"

Поиск
Список
Период
Сортировка
От kaka
Тема ERROR: date/time field value out of range: "28/05/2004 02:15:57"
Дата
Msg-id 40B72E8D.8000804@darpha.com
обсуждение исходный текст
Ответы Re: ERROR: date/time field value out of range: "28/05/2004 02:15:57"  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список pgsql-general
I'm runnig Redhat 7.3 with postgresql 7.3.4 builded from sources and
upgraded recently. I receive this error ( never received before upgrade
) and I don' t know what to do.

Error while executing the query; ERROR: date/time field value out of
range: "28/05/2004 02:15:57"

SQL = "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
02:15:57','14100001','','00001','EUR',0.00,0.00,'F15012711 ',2.000,
48.60000,null,-40.00,-15.00,0.00,0.00,'001 ','','','P')"


In my log the message is :

ERROR:  date/time field value out of range: "28/05/2004 02:15:57"
HINT:  Perhaps you need a different "datestyle" setting.

I've tried change datestyle to Postgresql, European, and so, but nothing
happend.

Can you help me ?

    Ciao, Samu.





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

Предыдущее
От: xier@in.tum.de
Дата:
Сообщение: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Следующее
От: ofrick@bluewin.ch
Дата:
Сообщение: Re: How do I unsubscribe?