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 … Continue reading How do I find the next Monday/Tuesday/etc.. with SQL?
Tag: extract
How do I calculate the remaining days until the end of a calendar quarter?
It may sound overwhelming but it's actually quite simple, especially if you've already figured out how to: extract various time periods from a date get the end date of the current quarter calculate the number of days between two days As you'll see below - calculating the remaining days in current quarter is then nothing … Continue reading How do I calculate the remaining days until the end of a calendar quarter?
How do I extract part of a date with SQL?
You might often need to do this if you're to aggregate daily data stretching over a longer time period and yet retain the timing The standard way forward is to use theĀ date_part() function Below you can find its syntax within some of the most widely used database environments Curious for alternative approaches?