Using UTC time and using offset values can be one of the best ways to make sure you capture the correct local time based on region. In order to get the time information directly from SQL you can run the following query.

select * from sys.time_zone_info
order by name