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

date/time field value out of range

From: Samuele Brignoli <samuele(dot)brignoli(at)darpha(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: date/time field value out of range
Date: 2004-05-28 09:28:10
Message-ID: 40B7062A.1070904@darpha.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
I've upgarded my redhat 7.3 Linux box to Postgresql 7.3.4 but now some 
of my application managing timestamps fields fail on insert.

I' ve tried setting the locale, the date style variable without results. 
I'm lost .

    Can you hel me ?

    Bye, Samu.

-----------------

Error while executing the query; ERROR: date/time field value out of 
range: "28-05-2004 11:11:59"


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 
11:11:59','14100001','','00001','EUR',0.00,0.00,'F11012700 ',1.000, 
36.42000,null,-40.00,-15.00,0.00,0.00,'001 ','','','P')


pgsql-general by date

Next:From: Rory Campbell-LangeDate: 2004-05-28 11:22:47
Subject: pg_dump and schema namespace notes
Previous:From: Richard HuxtonDate: 2004-05-28 08:05:52
Subject: Re: Database Size Limiting

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