By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

date issue

P: n/a
i have created two db's on two servers with same command
db2 create db sample on f: using codeset ibm-1252 territory gb

now when i run db2 values char(current date)
one gives 10/12/2007
and other 12/10/2007

even the regional settings on control panel are same for both.
what can be the probable reason and solution.

i can not change the code(char(sdf,iso) etc ) as the application is
already live and too huge

Oct 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rahul wrote:
i have created two db's on two servers with same command
db2 create db sample on f: using codeset ibm-1252 territory gb

now when i run db2 values char(current date)
one gives 10/12/2007
and other 12/10/2007

even the regional settings on control panel are same for both.
what can be the probable reason and solution.

i can not change the code(char(sdf,iso) etc ) as the application is
already live and too huge
This has nothing to do with the database. What you are seeing is the
pretty print from the client. So investigate that end.
(territory of the shell that started CLP, etc, etc...)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Oct 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.