How does the time zone table (tzone_utc) table gets updated?
The function dbo.ConvertToDBTime listed in the documentation seems to do what we need but it returns NULL for Time Zones which have the Daylight Savings flag checked but no records for the date range being converted.
Is the function dbo.get_tzone_diff used? The version in our production environment refers to the table tzone which no longer exists. The version of this function I found in the demo database uses the newer tzone_utc table.