On Wed, Apr 6, 2011 at 11:24 AM, JC de Villa <jc.devi...@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)

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to