PostgreSQL Calculate Age From Birthdate

22. Apr, 2008 3 Comments 

SELECT EXTRACT(year from AGE(NOW(), '1985-08-21')) as "age";
PG

Author: admin

Random Posts

Digg Delicious Stumbleupon Technorati
0
Tutorials
, ,

3 Responses to “PostgreSQL Calculate Age From Birthdate”

  1. ネキ - neki chan Reply 12. Mar, 2009 at 9:44 pm

    nice . so simple . i’ve tried it =)

  2. Dimas Reply 15. Jul, 2009 at 8:58 am

    Have you used much PostgreSQL, what are your thoughts about it vs MySQL?

  3. Eduardo Reply 06. Jan, 2010 at 2:21 pm

    Thanx, very simple useful.

Leave a Reply