Question

Alliance: How does the Time Zone table (tzone_utc) get updated in v14.5 and v15.


Userlevel 2
Badge +6

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. 

 

 

 


2 replies

Userlevel 7
Badge +21

Hi Katherine,

Alliance has an automated process checking the registry of the Windows server several times per day.  If there is a change, it will update the table automatically.  When Microsoft updates the definitions for time zones, the table is updated.

 

Userlevel 2
Badge +6

Thank you for the info Phil. 

 

 

Reply