(Kibana -> Discover -> Reporting -> Generate & Download) How to format 'timstamp' field in CSV report

[anjanitsip]

Kibana version: 7.9.1

Elasticsearch version: 7.9.1

Server OS version:AWS

Browser version:crome

Browser OS version:Win10

Original install method (e.g. download page, yum, from source, etc.):

Description of the problem including expected versus actual behavior:

Steps to reproduce:

1. We have store the logs in elastic search using fluentd. We are generating a report from kibana UI
2. Kibana -> discover -> Reporting -> Generate and download CSV
3. In log we have a timestamp filed
4. In CSV file the format of timestamp is coming as '7/2/2021 2:38:00 AM'. The second and milli second part is trimmed.

How we can format the timestamp field in the CSV report.

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

Describe the feature:

[dmlemeshko]

Hi @anjanitsip

Please use discuss.elastic.co to address questions about Kibana and other products. There is a chance that you will find a similar question with already mentioned solution. While answering the question on forum, we might confirm the issue and ask to report it.

As for your question I suggest to check this comment

Regards, Dima

[anjanitsip]

Hi Dima

Thank you for quick response -

I have tried to change the timestamp format using advanced settings -

'x' is Unix Millisecond Timestamp.

Change timestamp format reflects in the Kibana UI.

CSV file timestamp format is not changing - (still coming as before)

Even for the Default Date Format, timestamp format is the same as - '07/02/2021 11:41:00 am' (trim the seconds and millisecond part).

I want to change the timestamp format in the CSV file till milliseconds precision

I have tried multiple things with index and settings but not able to change the format of the timestamp in the CSV file.

Like YYYY-MM-DD HH:mm:ss.SSS

Please suggest

Regards
Anjani

[elasticmachine]

Pinging @elastic/kibana-reporting-services (Team:Reporting Services)

[elasticmachine]

Pinging @elastic/kibana-app-services (Team:AppServices)

[tsullivan]

Hi, if you are experiencing date formatting issues in 7.9.x, it could be a bug introduced in #67027

CSV formatting was re-written in 7.13: upgrading will fix your issue.