Essential SQL Server Date, Time and DateTime Functions

Just found this article on Essential SQL Server Date, Time and DateTime Functions. Has some handy functions you can add to get the following:

• Get just the date part of a DateTime value
• Get the time part of a DateTime value
• Create a DateTime value with explicit Day, Month, Year, Hour Minute and Second parts
• Create just a time value (with the date section set to a 'base' date)