Date and Time Data Type in SQL Server 2008 In this post we will discuss about Date and Time Data Type in SQL Server 2008. SmallDateTime: Defines date with the time of the day in 24-hour clock format. Requires fixed 4-bytes to store data. It can have date between January 1, 1900 through June 6, 2079 and time between […]