From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: upgrading from 7.3.5 to 8.1.5 |
Date: | 2007-01-01 17:30:07 |
Message-ID: | 5.2.1.1.0.20070101121937.024c53d0@pop6.sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
At 12:21 AM 12/31/06, Frank Bax wrote:
>At 08:09 PM 12/30/06, Tom Lane wrote:
>
>>Frank Bax <fbax(at)sympatico(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2007-01-01 19:56:06 | 2007 DST change not working |
Previous Message | Frank Bax | 2006-12-31 05:21:38 | Re: upgrading from 7.3.5 to 8.1.5 |