Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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:
You can change the date_order option for the duration of each connection.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|