SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 01:07 PM
| ||||
| ||||
 date issue 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      |
|
02-27-2008, 01:07 PM
| ||||
| ||||
| Re: date issue 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 |
 |
« questions on db2 workgroup server edition on MSCS
|
Hiring! DB2 DBA for SAP Environment - Direct Hire, Phx. Az »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:41 PM.
