SQL Dates and Times

I always have trouble remembering the basic code for manipulating datetimes in SQL server Jeff has posted them in his blog with a few others. In addition there are the functions that Michael has posted for calculating the start of a given time period.