1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Sybase
  5. Understanding What's Supported for Sybase
  6. Supported Sybase Data Types
  7. Dates and Timestamps

Dates and Timestamps

  • BIGDATETIME

  • BIGTIME

  • DATE

  • DATETIME

  • SMALLDATETIME

  • TIME

Limitations of Support

  • Oracle GoldenGate supports timestamp data from 0001/01/03:00:00:00 to 9999/12/31:23:59:59. If a timestamp is converted from GMT to local time, these limits also apply to the resulting timestamp. Depending on the time zone, conversion may add or subtract hours, which can cause the timestamp to exceed the lower or upper supported limit.

  • Oracle GoldenGate does not support negative dates.