SQL Remote User's Guide
Principles of SQL Remote Design
How data types are replicated
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'
For more information, 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.
If the consolidated database is an Adaptive Server Anywhere database, 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.
If the consolidated database is an Adaptive Server Enterprise database, ensure that the order of year, month, and day in the SQL Remote settings is consistent with the dateformat setting in the Adaptive Server Enterprise database.
To find the dateformat settings on an Adaptive Server Enterprise database
Login to the Adaptive Server Enterprise database from isql using the login ID used by ssremote. In this example, we use ssr for this login ID.
Issue the following command:
select * from master..syslogins where name = 'ssr' go
Adaptive Server Enterprise returns the default language for the ssr user.
If ssr uses the default language (us_english) then the default dateformat is YMD. If the language is different from the default, enter the following command:
sp_helplanguage language-name
where language-name is the language in use by the ssr user. The information displayed includes the default date format for the language.