Question on timezone and DST in T/SQL

• 問題

• 

  

  0

  登入以投票

  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.

  2009年12月30日 上午 01:11

  回覆

  |

  引述