Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajvijaymohan
Starting Member
2 Posts |
 Posted - 2006-09-08 : 08:11:51
|
| Where can i change the date stored internally to SQL Server. It is this value which is displayed when we execute getdate() function. But, Changing the system date doesn't change the result of getdate() function. I want to get a different value for getdate(). Is it possible ?Mohan |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-08 : 08:47:19
|
| Change the system date of the machine where SQL Server (mind it, Server not the client tools) is installed !Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-09 : 08:16:57
|
| Dont modify server settings. In your front end application, format it the way you wantMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Changing SQLServer Date