Learn to use SQL Server Date Functions
CRANK

SQL server’s date functions provide you a set of function that you can use to manipulate dates.  The function are used for a wide variety of operation such as adding weeks to a date, calculating the difference between two dates, or to decompose a date into its fundamental parts.

essentialsql.com
Related Topics: Microsoft SQL Server