# Component Error Time series chart with a query

**URL:** <https://forum.inductiveautomation.com/t/component-error-time-series-chart-with-a-query/97731>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 24, 2024, 2:04pm UTC](https://forum.inductiveautomation.com/t/component-error-time-series-chart-with-a-query/97731 "2024-10-24T14:04:43Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ryan.perretta](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.perretta/32/75110_2.png) [@ryan.perretta](https://forum.inductiveautomation.com/u/ryan.perretta)\
**Post date:** [October 24, 2024, 3:40pm UTC](https://forum.inductiveautomation.com/t/component-error-time-series-chart-with-a-query/97731/4 "2024-10-24T15:40:13Z")

</div>

Take a look at this topic. Could possibly be an issue with the timestamp coming in as `datetime2` type. I have not read through the whole thing, but it may work if you were able to convert the timestamp to a `datetime`

> [@Datetime2 format in EasyChart](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815):
>
> Hi Is it possible to use MSSQL server datetime2 format in EasyChart DB pens? Now it seems to try use datetime even error message says that format should be date? We would like to get millisecond resolution to trend from our data and easiest way is to use datetime2. Br Tommi Vahtera THT Control Oy

---

_[View the full topic](https://forum.inductiveautomation.com/t/component-error-time-series-chart-with-a-query/97731)._