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",


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

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

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