Different data types for time

System.DateTime is only one type for date and time in .NET

Update:

Very good articles about SQL Server date and time types: http://msdn.microsoft.com/en-us/library/ms187819.aspx and http://msdn.microsoft.com/en-us/library/ms186724.aspx