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 |
|
ckuo@kahluadesigns.com
Yak Posting Veteran
58 Posts |
 Posted - 2004-01-30 : 18:27:52
|
| Hi,If i have two dates i want to compare, but they are in different timezones, is there a function that factors this in? Or do I have to manually convert both dates into the same time timezone first before I compare? If there is a way, does it consider time zones that participate in daylight savings or not? Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-30 : 18:33:34
|
| There is no built in function to do this for you.I wrote a function that can do it though. Search the forums for udf_Timezone_Conversion. It requires two additional UDFs and one table with about 30 rows or so in it. And yes it considers daylight savings time. The timezones in the table are the only timezones that it supports. But it's most of them anyway.Let me know if you can't find the UDF in the forums.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Datediff and Timezone