From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
---|---|
To: | Ben <bench(at)silentmedia(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: birthday calculation |
Date: | 2003-07-23 07:28:18 |
Message-ID: | Pine.LNX.4.44.0307230927220.20834-100000@kix.fsv.cvut.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-07-23 07:29:05 | Re: String Comparison / Embedded Spaces |
Previous Message | Jean-Christian Imbeault | 2003-07-23 07:24:26 | Re: 0/1 vs true/false |