Easy Chart: convert varchar to datetime

Ignition
1

Hi All,

I want to Chart Value from a data base with Easy Chart. In my table the date has the format yyyy-mm-ddT hh:mm:ssZ as a VARCHAR.
image

In Easy Chart Customizer when I select the time Column i have this error: “The type of time column ‘date’ is not a date”.

image
image647×560 47.6 KB

This is normal because date is a VARCHAR
image

In Easy Chart, how or where can i convert this VARCHAR to a datetime?

Thank you for you help!

2

You will need to create a view in your database that uses CAST() or CONVERT(). Supply the view name instead of the table name.