Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.