KB-35064: Converting an EventTimeDbl field into Date/Time format and displaying it on E3Browser

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

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.

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *