SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.

Datetime Default

SQL Server Function to return a range of dates

A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.

UDF_GET_NEXT_WEEKDAY

A simple way of getting the next weekday's dates...

Get next 1st thursday

Function to get the 1st thursday from the given day.

Holiday List

A table UDF to return a list of holidays for a given year.

Find Last Day of the Month

Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.

Function to get number of days in month

Function to get number of days in month

UDF_GetGMTOffset

Calculates the offset between the UTC time and the SQL Server's local time.

A Flexible Day Of Week Function

A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.