On Wed, Apr 6, 2011 at 11:24 AM, JC de Villa <jc.devilla@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
