Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.

Binary Date Conversions

DynamicDateRangeGenerator

Generates # of dates in before/after current year.
No more hardcoded date ranges.

Calculate Age (in years)

An inline table valued function (iTVF) that can be used to calculate age in years.

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently

In The Beginning

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.

PivotByDate clr stored procedure

This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.

Function to format a datetime variable by a mask

I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.