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 … Continue reading How do I find the last day of the previous/next month with SQL?

How do I add times to a date with SQL?

  Yes, that's right. However, apart from the ones we discussed a while ago,  Vertica and MySQL also offer a few more ways on which you can fall back if you'd like to have simpler syntax. These are: DB Function Comment Vertica add_months(timestamp, unit) adds months to a date MySQL adddate(timestamp, unit) adds days to … Continue reading How do I add times to a date with SQL?