How do I handle the dates properly

(James) #1

We have transactions rolling in from different logs in different timestamp formats.

Would like the users to have the ability in Kibana to display the timestamps in their local TZ - what's the proper way of handling the data - should we convert all of the input dates into UTC?

Is there an example available on how to convert dates from one format to another, plz?

(Magnus B├Ąck) #2

The date filter will convert the input timestamp to UTC which Kibana will adapt to the browser's timezone. However, except for the @timestamp field which is mapped as a timestamp by default I'd assume that you'd have to tell ES (typically via an index template) that all your timestamp fields should be mapped as such.

(system) #3