# Show a Timestamp in a Numeric Label

**URL:** <https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251>\
**Category:** Ignition\
**Created:** [May 9, 2017, 8:50pm UTC](https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251 "2017-05-09T20:50:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathanlowery](https://avatars.discourse-cdn.com/v4/letter/j/7ab992/32.png) [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\
**Post date:** [May 9, 2017, 8:50pm UTC](https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251/1 "2017-05-09T20:50:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [May 9, 2017, 11:37pm UTC](https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251/2 "2017-05-09T23:37:00Z")

</div>

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

Suggested links:

> <https://stackoverflow.com/questions/12524537/convert-utc-milliseconds-to-datetime-in-sql-server>

> <https://stackoverflow.com/questions/3650320/convert-bigint-to-datetime>