I have MySQL table having a field as value as int and time as int, and i am storing epoch in the time field in UTC.
when i use this table in grafana with mysql datesource it shows me correct output.
I am using timezone as UTC then it shows me the correct value
Now i want to convert it into IST(UTC+5.30) so I select timezone as Local browser time, still it shows time in UTC.
So my question is, can grafana convert time UTC to Local browser time to data in a column.
Here my query:
select value , from_unixtime(time) as “TIme” from tab where value=“2”;
output:
value TIme
2.00 2018-06-06T06:44:23Z