# Invalid date format for ingest timestamp

**URL:** https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272
**Category:** Elasticsearch
**Created:** [April 16, 2020, 8:15am UTC](https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272 "2020-04-16T08:15:40Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Adam\_Szaraniec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adam_szaraniec/32/66418_2.png) [@Adam\_Szaraniec](https://discuss.elastic.co/u/Adam_Szaraniec)
#### Post date: [April 16, 2020, 8:15am UTC](https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272/1 "2020-04-16T08:15:40Z")

</div>

I need some help with pipeline (set ingest.timestamp)

```auto
{
"set": {
  "field": "meta.timestamp",
  "value": "{{_ingest.timestamp}}"
}
}

```

I've defined this pipeline, and mapping for this field is

```auto
    type: date
    format: "yyyy-MM-dd'T'HH:mm:ss.SSSSSSZZ"

```

However when I try to reindex documents I got error

> failed to parse field [meta.timestamp] of type [date] in document with id  
> "reason": "Invalid format: "2020-04-16T08:00:14Z" is malformed at "Z""

I am using ES 6.8.  
Any clues? How its possible that {{\_ingest.timestamp}} has not valid format ?

Similar when I do create lot of documents in short period of time, I got similar error (happen very rarely )

I've test it in Java

```auto
    public static void main(String[] args) {
        for (int i = 0; i < 999999; i++) {
            System.out.println(ZonedDateTime.now(ZoneOffset.UTC));
        }
    }

```

and it seems that Java 'truncate' output

> 2020-04-16T08:23:27Z  
> 2020-04-16T08:23:27Z  
> 2020-04-16T08:23:27.001Z  
> 2020-04-16T08:23:27.001Z  
> 2020-04-16T08:23:27.001Z

How is correct way to use ingest.timestamp, if its format is not consistent ?

---

<div class="post-metadata">

### Author: ![Adam\_Szaraniec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adam_szaraniec/32/66418_2.png) [@Adam\_Szaraniec](https://discuss.elastic.co/u/Adam_Szaraniec)
#### Post date: [April 27, 2020, 11:04am UTC](https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272/2 "2020-04-27T11:04:26Z")

</div>

Same on ES 7.6.2

---

<div class="post-metadata">

### Author: ![Adam\_Szaraniec](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adam_szaraniec/32/66418_2.png) [@Adam\_Szaraniec](https://discuss.elastic.co/u/Adam_Szaraniec)
#### Post date: [May 4, 2020, 4:02pm UTC](https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272/3 "2020-05-04T16:02:10Z")

</div>

Any updates?

---

<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: [June 1, 2020, 4:02pm UTC](https://discuss.elastic.co/t/invalid-date-format-for-ingest-timestamp/228272/4 "2020-06-01T16:02:14Z")

</div>

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