Technical FAQs

Ask a Question

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

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

SQL Server Management Studio

*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 ?