# Perspective Table not Rendering DateTime Data

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [April 12, 2024, 9:29am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731 "2024-04-12T09:29:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AAC](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@AAC](https://forum.inductiveautomation.com/u/AAC)\
**Post date:** [April 12, 2024, 9:29am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/1 "2024-04-12T09:29:05Z")

</div>

Hello everyone,

I am new here, I am having problems with the display of Date Type data in the perspective tables, the rendering does not work for me. Does anyone have an idea what I'm doing wrong?

I am reading the data from the alarm database and displaying it in a table... attached image.

 ![Screenshot 2024-04-12 112228](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/3/83e944bd237a4249da4d6f312fa96c34ab408bf0.png)

Thank you.

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [April 12, 2024, 9:35am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/2 "2024-04-12T09:35:07Z")

</div>

Where does the data come from ?  
This looks like alarm events, are you using the `system.alarm.*` functions ?

---

<div class="post-metadata">

**Author:** ![AAC](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@AAC](https://forum.inductiveautomation.com/u/AAC)\
**Post date:** [April 12, 2024, 9:46am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/3 "2024-04-12T09:46:24Z")

</div>

Nop, database query tag... from DB Alarms

 ![Screenshot 2024-04-12 114509](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/8/e84cabc1e4bcb41d8ea446ef9fff7b3ce59e3a66.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 12, 2024, 11:42am UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/4 "2024-04-12T11:42:26Z")

</div>

If you go back to the Dataset Editor and use the _Copy to clipboard_ button, what is the type of the eventtime column? It needs to be **L** (long) and not **str**.

For example:

```auto
"#NAMES"
"City","Population","Timezone","GMTOffset","TimeStamp"
"#TYPES"
"str","I","str","I","L"
"#ROWS","5"
"New York","8363710","EST","-5","1712910740411"
"Los Angeles", ...

```

I'm wondering if this is an SQLite issue and you might need to get a grow-up's database.

* * *

Actually, I've just remembered, you can check the datatype by clicking a cell in the Dataset editor.

* * *

Brain slow today: Notice that Dataset Editor is showing all the numeric columns right-justified but eventtime is left justified. I think it's a string.

---

<div class="post-metadata">

**Author:** ![AAC](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@AAC](https://forum.inductiveautomation.com/u/AAC)\
**Post date:** [April 12, 2024, 12:22pm UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/5 "2024-04-12T12:22:18Z")

</div>

String for sure.... issue solved using 'fromMillis' after casting to Int, now works.

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

Thanks!

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 12, 2024, 12:26pm UTC](https://forum.inductiveautomation.com/t/perspective-table-not-rendering-datetime-data/88731/6 "2024-04-12T12:26:28Z")

</div>

Good stuff. There's a "Solution" link below my post. If you hit that it will help future readers / searchers. Thanks.