Transformation of Unix Time Stamp - Global Setting Possible

Grafana MySQL
1

Hi Community,

I am quite to this forum so any help is really appreciated.

I am pulling data from MySQL db. The DB stores the timestamp in Unix Timestamp. I know I can use “Transformation” to convert to human readable but it looks like I have to do this on every Dashboard and Panel. Is there a way to set this on a global level so whenever I use the that DB column, it always converts it to human readable?

Thanks
Mustafa

2

Hi Mustafa,

You can use the from_unixtime() function in your queries, that way you are converting at source, and it will be correct on every dashboard and panel:

SELECT
from_unixtime(timestamp, ‘%Y %D %M %H:%i:%s’)
FROM
your_table

1 Like
3

Hi @sowdenraymond, but I have to do this in every query correct?

4

If you use views or stored procedures you only need to change it in one place