# Pulling timestamp from a table

**URL:** <https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784>\
**Category:** Ignition\
**Created:** [March 21, 2011, 4:04pm UTC](https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784 "2011-03-21T16:04:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Henry](https://avatars.discourse-cdn.com/v4/letter/h/df705f/32.png) [@Henry](https://forum.inductiveautomation.com/u/Henry)\
**Post date:** [March 21, 2011, 4:04pm UTC](https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784/1 "2011-03-21T16:04:51Z")

</div>

I have a table created from an SQL query. The columns of the table are bound to properties and use this expression.(toFloat({Root Container.Table 8.data}[0,1])) This allows me to use the numeric data. My problem is that I need to get the time stamp from the first location of the table and I’m not sure of the function or syntax.

Thanks  
Henry

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [March 21, 2011, 4:18pm UTC](https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784/2 "2011-03-21T16:18:10Z")

</div>

To get the timestamp of the first location you just do the following:`{Root Container.Table 8.data}[0,"t_stamp"]`This gets the first row’s timestamp column. You can bind that to a date data type or you can cast it to a date.