title: Working with Time Zones in SSRS
body: <p>We store all our dates SQL Server 2008 database in UTC time in  DateTime columns. 
  I'm using SSRS to create reports and I need to convert all the times on the reports to the Time Zone of the computer where they're running the report from.</p>
  
  <p>I know could always just pass in the current timezone offset as a parameter to the report and add or subtract the offset from the timezone, but this wouldn't correctly show historical dates because of daylight savings.</p>
  
  <p>Does SSRS have any functions that handle this?  Should I pass the timezone to the SQL server functions and have the SQL Server convert the time?</p>