Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
February 4, 2000
A. Use this code (courtesy of Microsoft PSS) :-
declare @deltaGMT int
exec master.dbo.xp_regread
'HKEY_LOCAL_MACHINE',
'SYSTEMCurrentControlSetControlTimeZoneInformation',
'ActiveTimeBias',
@DeltaGMT OUT
select getdate() as LocalTime, dateadd(minute, @deltaGMT, getdate() ) as GMT
You May Also Like