Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD

Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.

Dateadd with a numeric value

Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

Exploring the DATE Functions in SQL

Learn more about using the DATEADD function in SQL...

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.

Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.

Last month Name and Year in a SSRS expression

Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year