Variable - MySQL Query - Timestamp Converted To Unixtime

Grafana Configuration
,
1

I am using Grafana 8.3.4
In the Dashboard Settings->Variables, I am using MySQL query as the data source.
Even though the values are stored in datetime format in database, it is getting converted to unixtime in variables.

For eg: values in the database - 2022-01-20 05:39:34

How to get the values as datetime format?

chrome_mEC4jSQGHS
chrome_mEC4jSQGHS1701×575 32.5 KB

2

I don’t know exactly how you’re using these values, or where, but you could try experimenting with convert field type transformation:

might be able to transform them back out of epoch format?