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

[kaka]

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(p rcod_id,prdator d,prcodcli,prco dage,prcodlis,p rcodval,prscocl 1,prscocl2,prco dart,prqtaord,p rprezzo,prdatev a,prscont1,prsc ont2,prscont3,p rscont4,prcodde s,prconprg,prfl gcon,prstaord)
values (1,'28/05/2004
02:15:57','1410 0001','','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

[Rory Campbell-Lange]

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


On 28/05/04, kaka (kaka@darpha.co m) wrote:[color=blue]
> 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(p rcod_id,prdator d,prcodcli,prco dage,prcodlis,p rcodval,prscocl 1,prscocl2,prco dart,prqtaord,p rprezzo,prdatev a,prscont1,prsc ont2,prscont3,p rscont4,prcodde s,prconprg,prfl gcon,prstaord)
> values (1,'28/05/2004
> 02:15:57','1410 0001','','00001 ','EUR',0.00,0. 00,'F15012711 ',2.000,
> 48.60000,null,-40.00,-15.00,0.00,0.00 ,'001 ','','','P')"
>[/color]
Looks like there is a return in your date data. Also, is it a date field
or a timestamp field? What happens if you insert '2004-05-28'?

Rory
--
Rory Campbell-Lange
<rory@campbel l-lange.net>
<www.campbell-lange.net>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Rory Campbell-Lange]

Re: ERROR: date/time field value out of range: &quot;28/05/2004 02:15:57&quot;

On 28/05/04, kaka (kaka@darpha.co m) wrote:[color=blue]
> It' s not a return or so stupid problem. If I put 2004-05-28 It works
> perfectly. I don't want date in this format![/color]
[color=blue]
> Rory Campbell-Lange ha scritto:[color=green]
> >On 28/05/04, kaka (kaka@darpha.co m) wrote:[color=darkred]
> >>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,prdat ord,prcodcli,pr codage,prcodlis ,prcodval,prsco cl1,prscocl2,pr codart,prqtaord ,prprezzo,prdat eva,prscont1,pr scont2,prscont3 ,prscont4,prcod des,prconprg,pr flgcon,prstaord )
> >>values (1,'28/05/2004
> >>02:15:57','14 100001','','000 01','EUR',0.00, 0.00,'F15012711 ',2.000,
> >>48.60000,null ,-40.00,-15.00,0.00,0.00 ,'001 ','','','P')"[/color][/color][/color]

What does \d kleweshp_pror say?
--
Rory Campbell-Lange
<rory@campbel l-lange.net>
<www.campbell-lange.net>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org