Apart from the standard datediff() and timestampdiff(), Vertica and MySQL offer a couple of more ways to go about it: By using the age functions: age_in_years (current date, start date) and age_in_months (current date, start date) A key thing to remember about these two is that, unlike datediff ('years', start date, current date), they will calculate the months/years between the … Continue reading How do I find the difference between two time periods?