Date and time are inseparable
Storing date and time data can be a challenge in SQL Server because the only mechanism for storing this kind of data doesn't let you separate the date—day/month/year—from the time. SQL Server developers might hope for a separation between date and time in future SQL Server releases, but for now, you have to use one data type (either datetime or smalldatetime) when you store date- and time-related data.
Be...