Re: AGE function

--- Michael Fuhr <mike(at)fuhr(dot)org> wrote:

> On Tue, Sep 06, 2005 at 10:05:06PM -0700, Louise
> Catherine wrote:
> > When I execute this statement :
> > select AGE(TO_DATE('20041101','yyyymmdd'),
> > TO_DATE('19991201','yyyymmdd'))
> >
> > at postgre 7.3.3, the result :
> > age
> > ---------------------
> > 4 years 11 mons 1 day
> >
> > at postgre 8.0.3, the result :
> > age
> > ---------------
> > 4 years 11 mons
> >
> > My question :
> > 1. How does postgre 7.3.3 calculate AGE function?
> > 2. Why the result produced by postgre 7.3.3
> > is different from postgre 8.0.3 ?
>
> I get the same answer ("4 years 11 mons") in 7.2.8,
> 7.3.10, 7.4.8,
> 8.0.3, and 8.1beta1. Have you verified that
> to_date() is returning
> the correct dates? What are the results of the
> following queries
> on each of your systems?
>
> SELECT TO_DATE('19991201','yyyymmdd'),
> TO_TIMESTAMP('19991201','yyyymmdd');
> SELECT TO_DATE('20041101','yyyymmdd'),
> TO_TIMESTAMP('20041101','yyyymmdd');
> SHOW TimeZone;

at PostgreSQL 7.3.3 :
to_date to_timestamp
---------- ---------------------
1999-12-01 1999-12-01 00:00:00+07
to_date to_timestamp
---------- ---------------------
2004-11-01 2004-11-01 00:00:00+07
TimeZone
-----------
unknown

at PostgreSQL 8.0.3 :
to_date to_timestamp
---------- ---------------------
1999-12-01 1999-12-01 00:00:00+07
to_date to_timestamp
---------- ---------------------
2004-11-01 2004-11-01 00:00:00+07
TimeZone
------------
Asia/Jakarta

> What operating system are you using?
I'm using SuSE Linux 9.0 for the operating system

The result from your queries are similar, so what's
wrong in my queries? What should I do? Cause I must
migrate database from PostgreSQL 7.3.3 to
PostgreSQl 8.0.3.

> BTW, it's "PostgreSQL" or "Postgres," not "postgre."
Sorry about the name :)

Thanks,
Louise

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com