Hello, I’m trying to visualize the trend data recorded by Codesys PLC. It writes the trends to SQLITE file with UNIXTIMESTAMP as DataTime. When I try to convert it in Grafana, the calculated Date Time is not correct. the Online converter shows the right date-time for the same value. please see …

Hi, Is your Grafana timezone set correctly? Good Luck

Hello, It is set to CET, the PLC which created the sqlite file - too.

Hi, Check if this works for you : [image] Problem with epoch timestamps to human readable date conversion Stat Panel Hello, I have the same problem. Managed to solve? Good Luck

Hello, no, it doesn’t work. I tried different metrics for data field (’/1000’ , ‘*1000’) but the retrieved date-time is not correct. Please look at the year values, it is weird and seems like a random one (actually it is March 2021) [Test2] in JS this function gives the correct value: var unixTs…

Which Grafana version are you using ?

SQLITE as a Source: wrong unitstamp to date transformation

Grafana

wlargou March 15, 2021, 1:47pm 4

Hi,

Check if this works for you :

Good Luck

Topic		Replies	Views
Formatting sqlite timestamp recognizable time Time Series Panel	4	7088	October 29, 2021
Time series with datasource sqlite Grafana	2	7558	September 5, 2021
Sqlite datasource/plugin help Configuration	2	695	April 24, 2021
Grafana 7.0 Plugin Date Time from epoc on Dashboard Grafana	0	316	June 15, 2020
The date & time of datetime/timestamp columns not being read correctly Time Series Panel datasource	5	5264	October 4, 2023

SQLITE as a Source: wrong unitstamp to date transformation

Related topics