Different data types for time

Question

What are the different data types for time attributes in SQL Server 2008.

Answer 1

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