Millisecond Support for timestamp Parameter for ECDA Option for Oracle

Two configuration properties, timestamp_ms_support and timestamp_format, are available to allow ECDA Option for Oracle to insert, update, delete, and select Sybase DATETIME datatypes with the millisecond portion mapped to an Oracle TIMESTAMP column.

Configuration Properties Description
timestamp_ms_support

Specifies the value of the timestamp_ms_support parameter.

Value:
  • 0 – off (default)
  • 1 – on
timestamp_format

Specifies the Oracle timestamp format to be used by non-Adaptive Server clients.

Value:
  • MON DD YYYY HH:MM:SSAM – (default) provides the date and time in seconds, and the milliseconds portion contains 000 (zeros).
  • MON DD YYYY HH:MS:SS.FFAM – provides the date and time in milliseconds.