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

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: kaka <kaka(at)darpha(dot)com>
Cc: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: date/time field value out of range: "28/05/2004 02:15:57"
Date: 2004-05-28 13:27:23
Message-ID: 20040528132723.GC13494@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 28/05/04, kaka (kaka(at)darpha(dot)com) wrote:
> 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')"
>
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(at)campbell-lange(dot)net>
<www.campbell-lange.net>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-05-28 13:39:20 Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous Message ofrick 2004-05-28 12:30:35 Re: How do I unsubscribe?