From: Louise Catherine <r1c4n@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: AGE function
Date: Tue, 6 Sep 2005 22:05:06 -0700 (PDT)
Message-ID: <20050907050506.55141.qmail@web33402.mail.mud.yahoo.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: r1c4n@yahoo.com
Subject: Re: AGE function
In-Reply-To: <20050907050506.55141.qmail@web33402.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox