AGE function - Mailing list pgsql-sql

From Louise Catherine
Subject AGE function
Date
Msg-id 20050907050506.55141.qmail@web33402.mail.mud.yahoo.com
Whole thread Raw
Responses Re: AGE function
Re: AGE function
Re: AGE function
List pgsql-sql
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 ?

Thanks,
Louise

    
______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Statistics from Sequences
Next
From: Michael Fuhr
Date:
Subject: Re: AGE function