Well, this may or may not be a SQL question but . . .
I'm using the timezone functions referenced in the second post of this thread:
thread183-1262278
(thanks bborissov)
but I don't understand how to update the timezone table. The codeprojects post says:
"The tbTimeZoneInfo table contains the Time Zone information for all the time zones from the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. Anyone familiar with the TIME_ZONE_INFORMATION structure will recognize the structure of table tbTimeZoneInfo."
and
"Values in the tbTimeZoneInfo can be changed as needed. The values that are supplied in the form of SQL insertion scripts may not be up to date. They were obtained from the registry at a point in time and my now be out of date."
(I am not at all familiar with the registry so forgive me if the following is nonsensical)
How can I extract the the info from the registry?
Can this done on the SQL Server with T-SQL code?
Can I use an up-to-date file from any old Windows machine? I have Windows XP, but I can't find anything like HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.
Do I need special software to get the info out of the Windows system?
I'm using the timezone functions referenced in the second post of this thread:
thread183-1262278
(thanks bborissov)
but I don't understand how to update the timezone table. The codeprojects post says:
"The tbTimeZoneInfo table contains the Time Zone information for all the time zones from the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. Anyone familiar with the TIME_ZONE_INFORMATION structure will recognize the structure of table tbTimeZoneInfo."
and
"Values in the tbTimeZoneInfo can be changed as needed. The values that are supplied in the form of SQL insertion scripts may not be up to date. They were obtained from the registry at a point in time and my now be out of date."
(I am not at all familiar with the registry so forgive me if the following is nonsensical)
How can I extract the the info from the registry?
Can this done on the SQL Server with T-SQL code?
Can I use an up-to-date file from any old Windows machine? I have Windows XP, but I can't find anything like HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.
Do I need special software to get the info out of the Windows system?