following SQL query returns dates in local time (local to SQL server):
,DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), UnmanageFrom) as UnmanageFromLocalTime
,UnmanageFrom AS UnmanageFromUtcTime
,DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), UnmanageUntil) as UnmanageUntilLocalTime
,UnmanageUntil AS UnmanageUntilUtcTime
Unmanaged = 1 OR unmanagefrom >= GetUtcDate()
Does it help to achieve what you need or are you looking for something else?
This is exactly what I was looking for. Thanks a ton!