Chapter 6. Principles of SQL Remote Design
❖Tofind the dateformat settings on an Adaptive Server Enterprise
database
1. Login to the Adaptive Server Enterprise database from
isql
usingthe
loginID 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
AdaptiveServer Enterprise returns the default language for the ssr user.
3. Ifssr 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-nameisthe language in use by the ssr user. The
informationdisplayed includes the default date format for the language.
85