I would like to do timezone conversion (with daylight saving adjustment) from UTC time to local timezone. Since I am working in a global system, I need to convert the time to different local timezone according to the regions the record belonging to. So, I wonder if there is any built-in function in T/SQL or SQL Server to do the timezone conversion on datetime field (to any given timezone region, with considering daylight saving adjustment).
Or, if built-in function is not available, any other suggestion? (since I need to cater conversion in many different regions and still need to consider the DST, and potential changes in DST from time to time)
Thanks a lot.
Simon.