# DateTime as Int in database Table

**URL:** <https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 26, 2025, 11:56pm UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277 "2025-03-26T23:56:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Ford-King](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\
**Post date:** [March 26, 2025, 11:56pm UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277/1 "2025-03-26T23:56:39Z")

</div>

I'm working on a editable table and I'm having some issues with my DateTime data types. They are in integers when I click the cells to make an edit. Anyone experience this before?  
I'm entering into the table using the Time - DateTime Input if that makes any difference. It also shows like this when I dig into my tables props.selection.data tab

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/1/714f14b4a17c37ea7c84909276a0e21ea9cfcafb.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/d/3d511e1d611951fc861ae7dbbe87972ff36fa88a.png)  
Any help would be appreciated!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 27, 2025, 4:02am UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277/2 "2025-03-27T04:02:25Z")

</div>

You need to supply `props.columns` and specify date rendering for those values. Dates in Ignition are fundamentally UTC milliseconds since Jan 1, 1970, and since browsers don't have a built-in type to do this, you get those milliseconds. Ignition components that directly expect datetimes deal with this automatically. The table needs a hint for those columns.

---

<div class="post-metadata">

**Author:** ![Alex\_Ford-King](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\
**Post date:** [March 28, 2025, 11:04am UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277/3 "2025-03-28T11:04:49Z")

</div>

i have props.columns set up for all my columns and have the render set to date but still have the milliseconds displayed on my data and in my chart when i click to edit it

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d81304bd910b7f88238819f24b9c881ced345a6a.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 28, 2025, 11:51am UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277/4 "2025-03-28T11:51:11Z")

</div>

Yeah, you won't be able to edit it. You will need to use a cell render view that has a proper date entry component.