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|