Kibana changes timezone from UTC to CDT when exporting to CSV

Kibana changes timezone from UTC to CDT when exporting to CSV

We noticed that when we are  generating a report in Kibana, the resulting CSV changes all timestamps to CDT time rather than using the time zone configured i.e. Coordinated Universal Time (UTC).  The saved report timestamps are correct and match the timestamps in the raw message, while the timestamps in the generated CSV are off by 5 hours.

Kibana is using the OS timezone when you generate a report rather than using the timezone in advance settings. Elastic support was able to reproduce this issue and has created a bug for it.

As a work around,  Do the following:

Change the Timezone of Kibana Server.

timedatectl set-timezone UTC

Restart Kibana

systemctl restart kibana