| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jesse Scott <scotje(at)wwc(dot)edu> |
| Cc: | Postgresql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Timezone troubles |
| Date: | 2003-08-14 11:20:06 |
| Message-ID: | 15396.1060860006@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Jesse Scott <scotje(at)wwc(dot)edu> writes:
>> Ok, I was actually dyslexic when I read the version number, I have
>> 7.3.2 not 7.2.3, I'll investigate the timezone status though.
In that case I think you are looking for this 7.3.3 fix:
2003-02-27 16:37 tgl
* src/backend/utils/adt/timestamp.c (REL7_3_STABLE): Change
EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone
is assumed to be in local time, not GMT. This improves consistency
with other operations, which all assume local timezone when it
matters. Per bug #897.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-14 11:26:46 | Re: Timezone troubles |
| Previous Message | Jomon Skariah | 2003-08-14 08:19:05 | Re: Porting from PL/SQL to PLPGSQL |