Home Forums SQL Server 2005 T-SQL (SS2K5) getutcdate during daylight savings time RE: getutcdate during daylight savings time
MMartin1
One Orange Chip
Points: 27779
More actions
September 14, 2016 at 12:35 pm
#1900934
Just quick and dirty , I can get the offset as a integer with
SELECT
cast(
left(
right (
cast(SYSDATETIMEOFFSET() as varchar(40))
,6),3) as int)
Again , quick and dirty.
----------------------------------------------------