Re: Timezone troubles

Jesse Scott <scotje@wwc.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): ChangeEXTRACT(EPOCH FROM timestamp) so that a timestamp without
timezoneis assumed to be in local time, not GMT.  This improves consistencywith other operations, which all assume
localtimezone when itmatters.  Per bug #897.
 
        regards, tom lane