Re: BUG #1637: age() function is giving different results

Andrew - Supernews <andrew+nonews(at)supernews(dot)com> writes:
> I did some analysis for this one when it was mentioned just now in the irc
> chan. I can reproduce on 7.4.x as follows:

> test=> set timezone to 'America/Buenos_Aires';
> SET
> test=> select age(date '2005-05-05', date '1964-05-05');
> age
> -----------------------------------
> 40 years 11 mons 30 days 23:00:00
> (1 row)

Not for me --- I get "41 years" for that case. Since 7.4 depends on the
OS' timezone code, this is presumably OS-dependent. I'm using Fedora
Core 3, which has ... hmm ...

$ rpm -qf /usr/share/zoneinfo/America/Buenos_Aires
tzdata-2005f-1.fc3

... a pretty recent zoneinfo package. What's yours?

regards, tom lane