Show a Timestamp in a Numeric Label

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]

where point_id = ‘TWS_RU’ and
_val = 1

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

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

Suggested links: