Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Data types : Working with Datetime data types : Working with Oracle 9i and later releases
 
Working with Oracle 9i and later releases
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.