Technical FAQs

Ask a Question

Can I display database timestamps as Local Time rather than UTC?

Issue
The timestamps in the ION_Data database are stored in Universal Coordinated Time (UTC). A user would like to show these timestamps as Local Time. 

Product Line
Power Monitoring Expert 7.2.x
StuxureWare Power Monitoring 7.0.x

Environment
SQL Server Management Studio

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by
users familiar with SQL Server Management Studio. Databases should be backed up prior to
performing this procedure.* 


This article describes a simple workaround to display the timestamp in local time instead of UTC. The DATEADD() function adds or subtracts a specified time interval from a date when executing a sql query.

The following SQL query utilizes the DATEADD function to convert from UTC to Pacific time ( UTC -8) and creates a new temporary column ' localtime' that display the corresponding result:



The '-8' corresponds to Pacific Time (UTC -8) and will need to be changed to convert to other time zones. The figures below show Executed query results as well as the original query :

   
Another example :
  




 
Was this helpful?
What can we do to improve the information ?