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?