In ELK Stack 7.3 using Kibana and Canvas. So the issue I discovered in formatting @timestamp into a date time. This is the original message : {"@timestamp":"2019-10-08T16:35:14.455Z","hostname":"MYHost2","ip":"2.2.2.2","vm":"VM Desc 2","status":"UP","latency":"2ms"} This is my Elastic Search out…

I believe you're running into a timezone issue, which is something being tracked here: https://github.com/elastic/kibana/issues/33959

I understand that @timestamp is in UTC format. When I set the dateFormat:tz as UTC I would see same format in both Discover Table and JSON. [image] In Canvas I am not able to change format to my timezone. I tried many ways however I can only see the UTC format. [image]

Is there a workaround for this time format issue?

Formatting @timestamp in Canvas

Elastic Stack Kibana

bkleynbok (Boris Kleynbok) October 10, 2019, 8:17pm 3

I understand that @timestamp is in UTC format. When I set the dateFormat:tz as UTC I would see same format in both Discover Table and JSON.

In Canvas I am not able to change format to my timezone. I tried many ways however I can only see the UTC format.

Topic		Replies	Views
Canvas - @timestamp Kibana canvas	4	1802	January 6, 2019
Using Canvas with essql timestamp of YYYY-MM-DDTHH:MM:SS Kibana	2	1729	August 2, 2019
Canvas: duplicate date across table using formatdate Kibana canvas	3	1155	August 6, 2019
How to display a datefield in custom format in Kibana, without changing @timestamp display format? Kibana	4	1477	December 28, 2017
@timestamp field in Kibana is different from @timestamp field in index entry Kibana	5	13335	February 22, 2017

Formatting @timestamp in Canvas

Related topics