Skip site navigation (1) Skip section navigation (2)

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 17:01:02
Message-ID: 20040528170102.GA14772@campbell-lange.net (view raw or flat)
Thread:
Lists: pgsql-general
On 28/05/04, kaka (kaka(at)darpha(dot)com) wrote:
> 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!

> Rory Campbell-Lange ha scritto:
> >On 28/05/04, kaka (kaka(at)darpha(dot)com) wrote:
> >>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')"

What does \d kleweshp_pror say?
-- 
Rory Campbell-Lange 
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

In response to

pgsql-general by date

Next:From: Cyril VELTERDate: 2004-05-28 17:30:18
Subject: Dump 7.1.3->7.4.2
Previous:From: Manuel SugawaraDate: 2004-05-28 15:58:44
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group