How old am I?

[Deleted User] · April 2018

Jim Knicely authored this tip.

The AGE_IN_YEARS function returns the difference in years between two dates, expressed as an integer. This function is very useful when I forget how old I am or how old my wife is being that today is my wife’s birthday.

Example:

dbadmin=> SELECT extract(year from sysdate) "Current Year", age_in_years('04/05/1987') "How young does my wife think she is?";
 Current Year | How young does my wife think she is?
--------------+--------------------------------------
         2018 |                                   30
(1 row)

Have Fun!