Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » Understanding transaction log-based replication » Data types


Dates and times

When date or time columns are replicated, SQL Remote 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 SQL Remote to send a date of May 2, 1998 as 1998-05-02.

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

When replicating dates and times:

  • The time, date, and timestamp formats must be consistent throughout the SQL Remote system.

  • The order of the year, month, and day used for the date and timestamp formats must match the setting of the date_order database option.

  • The date_order option for the duration of each connection can be changed.

See also