Update only Year, Month or Day in a SQL Server Date

In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.

Binary Date Conversions

Calculate Age (in years)

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

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.

Date Format

Returns your date in the format mask you require.

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.

Return X Day of Month

This function will return the first, second, third, fourth or last day of a given month.