Skip to main content

Release Note

Support for Oracle TIMESTAMP data types

The Oracle TIMESTAMP data type is now fully supported throughout the Pega 7 data layer. The TIMESTAMP columns for data provide greater precision than the previously available DATE columns.

This release does not include any columns that use the TIMESTAMP data type at installation. However, after installation or upgrade:

  • Any newly created columns (for example, those created when optimizing a property or defining a new table) use the TIMESTAMP column type.
  • Any existing data still uses DATE values.
    • Oracle users can manually convert any existing DATE column types to use a TIMESTAMP column type instead.
    • Altering the column type for existing values in a column does not provide any greater precision for those values because they still use DATE values and not DATETIME values.

For more information, see DateTime property mapping in Oracle for Pega 7.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us