Comments by bezjakr (Top 2 by date)

My point is that if you have now 2 hours offset from UTC, then during summertime you have 3 hours offset from UTC. And since you calculate offset using GETDATE() and GETUTCDATE() you always get offset for particular time when you make a query which is off for one hours for all dates when the offset should be different than the current one. So if you had only 2 records where first created_on was 2011-06-30 01:00 and the second 2011-12-30 01:00, your method executed today would return 2011-06-30 03:00 and 2011-12-30 03:00, but correct would be 2011-06-30 04:00 and 2011-12-30 03:00 (offset for june should be 3 hours).