Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.





---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux