|
Map to MSS Date Time (Checked/ Unchecked)
|
Data type
|
Corresponding Legacy/MSSQL Server 2008 compatible data type
|
|
Checked (mapping provides backwards compatibility to earlier versions of MS SQL Server)
|
||
|
Date
|
DateTime
|
|
|
DateTime
|
DateTime datatype
|
|
|
Unchecked (Use Date, DateTime2 and DateTimeOffset datatypes introduced in MSSQL Server 2008 )
|
||
|
Date
|
Date
|
|
|
DateTime
|
DateTime2
|
|
|
DateTime-TZ
|
DateTimeOffset
|
|