Replication of dates and times

When date or time columns are replicated, the Message Agent uses the setting of the sr_date_format, sr_time_format, and sr_timestamp_format database options to format the date.

For example, the following option setting instructs the Message Agent to send a date of May 2, 1987 as 1987-05-02.

SET OPTION sr_date_format = 'yyyy-mm-dd';

See SQL Remote options.

The following points may be useful when replicating dates and times:

  • The time, date, and timestamp formats must be consistent throughout the installation.
  • Ensure that the order of year, month, and day used for the date and timestamp formats matches the setting of the date_order database option.

    You can change the date_order option for the duration of each connection.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0