Different data types for time

What are the different data types for time attributes i开发者_如何转开发n SQL Server 2008.

---

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