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

On Fri, Jan 15, 2010 at 9:38 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> "Jodi Escalante" <jescalante@assistgroup.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, =A02008-01-11 15:06:40.257000 -07:00:00,
>> 2008-01-11 00:00:00.000000 -07:00:00, =A02000.0, =A0NULL, =A0Initial,
>> 3452, 2147, =A0NULL, =A0N, =A0N, =A0N, =A0N)
>
> Without quotes you've got the calculation (2008 minus 1 minus 11)
> which equals the integer 1996. =A0It doesn't know what to make of the
> number which comes next. =A0Try something like TIMESTAMP WITH TIME
> ZONE '2008-01-11 15:06:40.257000 -0700'. =A0Similar issues seem to
> exist with most of your other literals.

Just as a note this might have appeared to work in pre-8.3 but may
have done the wrong thing.  Definitely quote your literals.

Best Wishes,
Chris Travers