The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How old am I?

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!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.