Vertica Quick Tip: How old am I?

Posted April 3, 2018 by Soniya Shah, Information Developer

This blog post was authored by Jim Knicely. 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 her 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!