How do I find the difference between two time periods?

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 …

How do I find the next Monday/Tuesday/etc.. with SQL?

Being able to calculate the date of the coming Thursday may come really handy if your sales revenue follows a very strong weekday pattern as it enables you to use weekdays, rather than fixed dates, as a basis for making your weekly financial projections. How do I do this in practice? Vertica offers a very …

How do I find the last day of the previous/next month with SQL?

Need to provide a daily estimation of how many clicks you'll make by the end of next month? Your client expects you to deliver a monthly report on their performance? That's when knowing how to get the last day of the current, previous or next month might come in handy Whereas Vertica and MySQL offer …