Example:
My son is turning 18 this year!
dbadmin=> SELECT age_in_years('06/13/2001');
age_in_years
--------------
17
(1 row)
I was curious to know how many months he’s been on the planet, so I figured that I could just multiply his current age by 12.
dbadmin=> SELECT age_in_years('06/13/2001') * 12 age_in_months;
age_in_months
---------------
204
(1 row)
But that’s not completely accurate. It does not take into account that we are already 4 months into the current year, or for any past Leap Years. Luckily there is a built-in Vertica function named AGE_IN_MONTHS that does!
dbadmin=> SELECT age_in_months('06/13/2001') actual_age_in_months;
actual_age_in_months
----------------------
214
(1 row)
Helpful Links:https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Date-Time/AGE_IN_MONTHS.htm
https://forum.vertica.com/discussion/239587/how-old-am-i
Have fun!
About the Author
James Knicely
Vertica Field Chief Technologist
I've had the privilege of working with many database technologies in my career. But after being introduced to Vertica in May of 2011 as a client, I was hooked on the new technology after witnessing a query run in milliseconds that had previously ran for hours on the legacy database we had in place. It was then that I knew I wanted to eventually join the Vertica team, and 4 years later I did! I am currently a Vertica evangelist and am ready to help you get on board! Please feel free to reach out to me with any questions you have about Vertica and make sure to follow my Vertica Quick Tips!
