Alex Rivera | Logout

What are equivalent C# data types for SQL Server's date, time and datetimeoffset?

Asked 2009-03-17T16:40:55.570
43

What are the most suitable equivalent C# data types for the date datatypes in SQL Server? I'm specifically looking for

  • date
  • time
  • datetimeoffset
c# sql-server-2008 types
Edit
Report

2 Answers

5

In C# you could use

answered 2009-03-17T16:50:45.517
4

The new types are supported only if you install .NET Framework 3.5 SP1.

  • SqlDbType.Date

  • SqlDbType.Time

  • SqlDbType.DateTime2

  • SqlDbType.DateTimeOffSet

For exhaustive information, see Date and Time Data in SQL Server 2008

answered 2009-03-17T16:46:37.163

Your Answer