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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2004-10-11 : 09:20:39
|
| I need to track all datetime in GMT(UTC) I think. My goal is to have all the submitted jobs based in GMT. As the uses login they will see they job in their (user preference) time zone. My assumptions are:I will need to create a function(something) to convert the GMT to the proper timezone per record.I will need to check if the users timezone is currently using summer time or daylight savings time.I will need some table to bang against to track the differences of timezones and Daylight savings time.I have seen Taras post.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30335&SearchTerms=daylight,savingsAnybody doing this? Anybody have any other ways? Can you point me in the right direction? What about a good source for all timezones, differences, summertime, daylight etc?Thanks |
|
|
|
|
|
DST again, concept