# Dateformat with milliseconds and Zimezone

**URL:** <https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460>\
**Category:** Elasticsearch\
**Created:** [March 15, 2024, 9:31am UTC](https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460 "2024-03-15T09:31:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![helldunkel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/helldunkel/32/133097_2.png) [@helldunkel](https://discuss.elastic.co/u/helldunkel)\
**Post date:** [March 15, 2024, 9:31am UTC](https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460/1 "2024-03-15T09:31:46Z")

</div>

Hi,

my timestamp is "2024-03-15T01:14:42.429088+01:00" but no pattern work for me.

yyyy-MM-dd'T'HH:mm:ss.SSSSSSX  
yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ  
yyyy-MM-ddTHH:mm:ss.ssssssTZD  
YYYY-MM-DDTHH:MM:SS.ssssss±HH:MM

can anybody help me?

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [March 15, 2024, 10:09am UTC](https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460/2 "2024-03-15T10:09:02Z")

</div>

It is generally useful to provide information about which Elasticsearch version you are using plus a full example that can be used to reproduce the issue. By just stating that it is not working it is not clear exactly what is not working nor what your expectations are.

The first thing to note is that the timestamp you have given as an example is not in millisecond precision (3 decimals) but in microseconds (6 decimals), The standard date mapping type only supports millisecond precision, so in order to use the full precision you may need to map your field as [date\_nanos](https://www.elastic.co/guide/en/elasticsearch/reference/8.12/date_nanos.html).

---

<div class="post-metadata">

**Author:** ![helldunkel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/helldunkel/32/133097_2.png) [@helldunkel](https://discuss.elastic.co/u/helldunkel)\
**Post date:** [March 15, 2024, 11:26am UTC](https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460/3 "2024-03-15T11:26:12Z")

</div>

I will grok it out or change the log systems. I don´t need microseconds.

---

<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:** [April 12, 2024, 11:26am UTC](https://discuss.elastic.co/t/dateformat-with-milliseconds-and-zimezone/355460/4 "2024-04-12T11:26:37Z")

</div>

Closed on April 12, 2024, 11:26am UTC

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