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 |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2009-07-24 : 10:15:48
|
| Hi all,How I can convert MST (system time) to local time in SQL 2000 server?Shaji |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-24 : 10:25:05
|
| Whats the differencve between your system time and local time?Use Dateadd() if it is always a set amount.Otherwise, how do you know where your user is in the world? If you have a table for your users, add the difference when the user sets their location and you can use this value in your dateadd(). |
 |
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2009-07-24 : 10:39:36
|
My server is in US (Denver) - MST time zone and my local time location is India.How I can see the difrence?Shajiquote:
Originally posted by RickD
Whats the differencve between your system time and local time?Use Dateadd() if it is always a set amount.Otherwise, how do you know where your user is in the world? If you have a table for your users, add the difference when the user sets their location and you can use this value in your dateadd().
|
|
|
|
|
|
|
Convert system time to local time