I have telegraf posting data into influx and that appends it’s own time column. However I have a created column that I would like to use in a table in grafana to show VMs snapshots created today. When I look at the field type in Influx Studio it says the field type is string.
When I write a query in grafanan can I cast that to date or something? Say
SELECT CAST(“created” AS date()) FROM “vmsnapshotage” WHERE $__timeFilter(created)