Re: birthday calculation

How come it gives 23 hours, is that correct?Pavel Stehule wrote: <blockquote type="cite"><pre wrap="">Hello

SELECT age(CURRENT_DATE, date '730715');          age
--------------------------30 years 7 days 23:00:00
(1 row)

bye
ps


On 22 Jul 2003, Ben wrote:
 </pre><blockquote type="cite"><pre wrap="">It must be late, because I cannot seem to figure this out. I've got a
field which has a user's birthday - I want to figure out how old they
are in terms of years.

If I just do something like:

select current_date - user.bday;

I get their age in days, which doesn't let me take leap years into
account. Is there a simple magic date_diff function that I'm missing? Or
lacking that some other way to get postgres to do the date calculations?


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your     joining column's datatypes do not match
   </pre></blockquote><pre wrap="">

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to <a class="moz-txt-link-abbreviated"
href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>
 </pre></blockquote><br /><br />