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!
