From: | kaka <kaka(at)darpha(dot)com> |
---|---|
To: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: date/time field value out of range: "28/05/2004 02:15:57" |
Date: | 2004-05-28 12:20:29 |
Message-ID: | 40B72E8D.8000804@darpha.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | ofrick | 2004-05-28 12:30:35 | Re: How do I unsubscribe? |
Previous Message | Lee Hanxue | 2004-05-28 12:19:31 | How do I unsubscribe? |