Tag Archives: Database

Date Maths – SQL Server

This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those – Microsoft SQL Server.

Please refer to the other articles in this series on DB2 and Oracle.

Rather than providing a list of all possible calculations I’ve focused on just listing the calculations that I’ve found occur often in a BI reporting or data analysis solution. I haven’t gone into details behind the calculations as this article should be treated as more of a reference than a tutorial and there are plenty of other articles available on the internet that explain in detail how to perform date calculations.

Continue reading

This article was published on March 17, 2009 by Al Gulland.