User's Manual

Chapter 6. Principles of SQL Remote Design
❖ To find the dateformat settings on an Adaptive Server Enterprise
database
1. 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.
2. Issue the following command:
select
*
from master..syslogins
where name = ’ssr’
go
Adaptive Server Enterprise returns the default language for the ssr user.
3. 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.
85