At 12:21 AM 12/31/06, Frank Bax wrote:
>At 08:09 PM 12/30/06, Tom Lane wrote:
>
>>Frank Bax <fbax@sympatico.ca> writes:
>> > 2) age() changed from 7.3.5 to 8.1.5?
>>
>>I see this in the 7.4.7 release notes:
>> Make age(timestamptz) do calculation in local timezone not GMT
>>It looks like the examples you cite are crossing DST boundaries, so
>>the one-hour difference is correct. Depending on what you are trying
>>to accomplish, you might wish to do the calculation in timestamp without
>>time zone.
>
>
>You mentioned GMT. Can I force age() to use GMT or can I convert
>timestamptz to GMT and then use age()?
I figured it out (I found section 9.9.3):
select age(hi_date at time zone 'GMT',lo_date at time zone 'GMT')+'1 min'
BTW: Why isn't timezone() function listed in table 9-26? Shouldn't "at
time zone" be considered an operator?
Frank