Working with Oracle 9i and later releases
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Oracle Release 9i and later provide support to three
specific date time data types - TIMESTAMP, TIMESTAMP with
TIMEZONE and TIMESTAMP with LOCAL TIMEZONE.
All three data types are supported by DataServer for Oracle through
the OCI driver. The values of all three data types are normalized to
the NLS timezone by the OCI driver before it is received into or
sent from the DataServer. Therefore, support of all Oracle datetime
data types and their interaction with Daylight Savings is seamless
at the OCI level.