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 |
|
abarsami
Yak Posting Veteran
68 Posts |
 Posted - 2001-03-23 : 13:37:58
|
| My server is 2 hours ahead. I need a way to get the user local time based on our server time (server side not client). I was wondering if anyone wrote a stored procedure to calculate the dates around the world based on where you were. Or any other way to calucalte the local date on the server side. It would adjust the server date so it would be the same as the users date anywhere in the world. It would add or subtract hours to the server date and time.Thanks |
|
|
|
|
|
Calculate Local Date based on Server Date