Re: Auto Adjust Age - Mailing list pgsql-general

From Carlos Mennens
Subject Re: Auto Adjust Age
Date
Msg-id BANLkTimOoau7P5bV=x8JBR3yPA6CacjHgA@mail.gmail.com
Whole thread Raw
In response to Re: Auto Adjust Age  (JC de Villa <jc.devilla@gmail.com>)
List pgsql-general
On Wed, Apr 6, 2011 at 11:24 AM, JC de Villa <jc.devilla@gmail.com> wrote:
> Theres also the age() function....
>
> SELECT age(dob);
>
> Should give you
>
>           age
> -------------------------
>  31 years 5 mons 17 days
>
> If you want to be really exact about it. :)

That worked awesome too!

ide=# SELECT age(dob) FROM users;
           age
--------------------------
 31 years 10 mons 12 days
(1 row)

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Why security-definer functions are executable by public by default?
Next
From: Christine Penner
Date:
Subject: adding years to a date field