AGE function

From: Louise Catherine <r1c4n(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: AGE function
Date: 2005-09-07 05:05:06
Message-ID: 20050907050506.55141.qmail@web33402.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message nathan wagner 2005-09-07 05:15:08 Re: uuid type for postgres
Previous Message Tom Lane 2005-09-07 04:24:11 Re: uuid type for postgres