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

Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jodi Escalante" <jescalante(at)assistgroup(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4
Date: 2010-01-15 17:38:10
Message-ID: 4B5053A2020000250002E588@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jodi Escalante" <jescalante(at)assistgroup(dot)com> wrote:
 
> INSERT INTO assessment (id, created, taken, current_weight, note,
> assessment_type, stay_id, contact_id, estimated_discharge_date, 
> cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp,
> ) VALUES ( 50,  2008-01-11 15:06:40.257000 -07:00:00,  
> 2008-01-11 00:00:00.000000 -07:00:00,  2000.0,  NULL,  Initial, 
> 3452, 2147,  NULL,  N,  N,  N,  N) 
 
Without quotes you've got the calculation (2008 minus 1 minus 11)
which equals the integer 1996.  It doesn't know what to make of the
number which comes next.  Try something like TIMESTAMP WITH TIME
ZONE '2008-01-11 15:06:40.257000 -0700'.  Similar issues seem to
exist with most of your other literals.
 
-Kevin

In response to

Responses

pgsql-bugs by date

Next:From: Chris TraversDate: 2010-01-15 18:40:31
Subject: Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4
Previous:From: Heikki LinnakangasDate: 2010-01-15 17:35:14
Subject: Re: BUG #5281: Timestamp fields not inserting from 8.3 to 8.4

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