Question on timezone and DST in T/SQL RRS feed

  • 問題

  • 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.


    2009年12月30日 上午 01:11