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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|