MySQL Epoch to Human readable date (Including the millisecond part)

Grafana MySQL
1

Hi all,

This is my first post and I am a newbie to grafana. I have connect to my local MySQL database in which I have a table with time field as EpochWithMicroSec(1516931641660) as Int(13) datatype and I want to use SQL query to get the human readable format that has millisecond part attached to the Timestamp like this ( 2018-01-25 5:54:01.660). I want to plot my time series graph on this millisecond date format. My SQL query is SELECT EpochWithMicroSec as time_sec from test11
but i only see the date as 01/25/2018 5:54:01 pm it is missing the millisecond part. Any suggestion how to get the millisecond part attached to the date?

Thank you in advance!

2

Try:

SELECT FROM_UNIXTIME(EpochWithMicroSec/1000) FROM test11

Doc: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime

Test:

> SELECT from_unixtime(1516931641660/1000)
2018-01-25 18:54:01.6600
3

Thank You @jangaraj your solution helped mel