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.

SQL Window Functions Series: LAG() and LEAD()

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

How to Find the Start and End Dates for the Current Week (and more)

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

Lockdown Minutes

Exploring the DATE Functions in SQL

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

Work around for calculating age using the SQL Server DateDiff function

Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.