# DateTime format in CSV report is not correct. 0's are being appended for nanos

**URL:** https://discuss.elastic.co/t/datetime-format-in-csv-report-is-not-correct-0s-are-being-appended-for-nanos/322612
**Category:** Kibana
**Tags:** docker
**Created:** [January 6, 2023, 11:09am UTC](https://discuss.elastic.co/t/datetime-format-in-csv-report-is-not-correct-0s-are-being-appended-for-nanos/322612 "2023-01-06T11:09:02Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![samee\_alam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samee_alam/32/100877_2.png) [@samee\_alam](https://discuss.elastic.co/u/samee_alam)
#### Post date: [January 6, 2023, 11:09am UTC](https://discuss.elastic.co/t/datetime-format-in-csv-report-is-not-correct-0s-are-being-appended-for-nanos/322612/1 "2023-01-06T11:09:02Z")

</div>

**ES and kibana version v 7.17.3**

When generating CSV report, datetime format is not correct.  
0's are being appended for micro and nano seconds, although document holds correct values.

 ![1](https://us1.discourse-cdn.com/elastic/original/3X/f/8/f8bfef485aa77d1f6f33084ae5323889f099a1a7.jpeg)  
 ![2](https://us1.discourse-cdn.com/elastic/original/3X/e/c/ec9a809d69df03e988cbe40cd9c4628387b8ae48.jpeg)

Tried playing around with advanced settings but still not able to solve this issue.

 ![3](https://us1.discourse-cdn.com/elastic/original/3X/4/a/4ada5839e344ff436f66d985c4c777957c35cac3.jpeg)

Please help ☹

---

<div class="post-metadata">

### Author: ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)
#### Post date: [January 18, 2023, 12:17pm UTC](https://discuss.elastic.co/t/datetime-format-in-csv-report-is-not-correct-0s-are-being-appended-for-nanos/322612/2 "2023-01-18T12:17:48Z")

</div>

I could reproduce this with `7.17.7` but I checked as well, and seems to be fixed on `8.6.0`.

I've tried but I can't find the PR that fixed this issue so I can't provide more details , sorry 😞

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 15, 2023, 12:18pm UTC](https://discuss.elastic.co/t/datetime-format-in-csv-report-is-not-correct-0s-are-being-appended-for-nanos/322612/3 "2023-02-15T12:18:08Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.