| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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')
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2004-05-28 11:22:47 | pg_dump and schema namespace notes |
| Previous Message | Richard Huxton | 2004-05-28 08:05:52 | Re: Database Size Limiting |