Show a Timestamp in a Numeric Label

Ignition
1

I am trying to do an SQL query but I only want the timestamp to display when it gets to a certain value. I cannot seem to get it to display due to datatype mismatches. I can get it in SQL manager using:

SELECT [timestamp]

FROM [dbo].[DATA_LOG]
where point_id = ‘TWS_RU’ and
_val = 1
GO

In Ignition it displays a long number but I cannot figure out how to convert that to a time/date.

2

Perhaps one of the posts from StackOverflow can help you with this.

Suggested links: