-- Reference: http://msdn.microsoft.com/en-us/library/ms174420.aspx
-- Section: Default Returned for a datepart That Is Not in a date Argument
-- "If the data type of the date argument does not have t…