Legacy mapping based on MAP to MSS DateTime:
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
The following table explains the mapping:
| 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 | |