Question:
How can I convert an EventTimeDbl field into Date/Time format and display it in an E3Browser?
Solution:
To do so, use the SQL CONVERT command below in the SQL tab of an E3Browser‘s Query.
SELECT CONVERT(datetime, EventTimeDbl) as DateTimeEvent
from AlarmsTable
from AlarmsTable
In this command, EventTimeDbl is the name of the field to be converted, DateTimeEvent is the new query’s title, and AlarmsTable is the query to be consulted.