From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | age() and DateStyle ISO |
Date: | 2002-02-23 17:57:05 |
Message-ID: | 3.0.6.32.20020223125705.0205a100@pop6.sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In an obscure part of my app that I haven't touched in many moons, I found
some code that contains:
SET DateStyle = 'ISO'
and then a SELECT age(timestamp,timestamp) from ...
In my php code I then tested
if ( strcmp( $row->age, "14 00:00" ) )
Sometime between 6.5.x [when the code was written] and 7.1 [current level]
the results from age() changed from "14 00:00" to "14 days"? I notice the
columns are now defined as 'timestamp with timezone' which was probably
automatic as part of one upgrade on another (they were simply 'timestamp'
in 6.5 as I recall).
Did the standard change? Was it never applicable to intervals?
Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2002-02-23 18:43:33 | Re: permissions |
Previous Message | tony | 2002-02-23 17:36:18 | Re: permissions |