Kibana + DateTime issues


(sarthak) #1

I am using logstash and collect CSV data and import into Elastic Search,

CSV Data

02/06/2016 01:01:32

Import to Elastic Search in Json format

"Timestamp": "02/06/2016 01:01:32",

Kibana

Json:
"Timestamp": "02/06/2016 01:01:32",

Table:
Timestamp: February 5th 2016, 18:02:32.000

Issues,
How i can fix correct Timestamp into Kibana same as JSON format ?


(Mark Walkom) #2

ES users UTC, KB use the browsers timezone.
So change your OS timezone to be UTC+0.


(sarthak) #3

Thanks, I got solution.


(Mark Walkom) #4

What was it?


(sarthak) #5

Here are the steps.

Kibana site -> Settings -> Advanced -> Field "dateFormat:tz" -> Select UTC


(system) #6