Here are the equivalent CLR data types for date
, time
and datetimeoffset
SQL Server data types:
date – DateTime
, Nullable<DateTime>
time – TimeSpan
, Nullable<TimeSpan>
datetimeoffset – DateTimeOffset
, Nullable<DateTimeOffset>
Note that you can find a listing of all SQL Server data types and their CLR equivalents here, Mapping CLR Parameter Data