# I can't ingest time longer than 24 hours

**URL:** <https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168>\
**Category:** Elasticsearch\
**Created:** [January 12, 2022, 1:41pm UTC](https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168 "2022-01-12T13:41:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eric\_Barreto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eric_barreto/32/83050_2.png) [@Eric\_Barreto](https://discuss.elastic.co/u/Eric_Barreto)\
**Post date:** [January 12, 2022, 1:41pm UTC](https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168/1 "2022-01-12T13:41:19Z")

</div>

I need to create a dashboard based on a json that will be ingested repeatedly, this json has 2 fields of type time the first field is TA and the second is TT.

The value of these fields is represented by HH:mm:ss, but this value can exceed 24 hours, for example:

TA  
58:45:21

TT  
69:48:22

I'm trying to ingest these fields using the data type: DATE and format: hour\_minute\_second, but I'm getting an error because the time is greater than 24 hours.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [January 13, 2022, 5:27am UTC](https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168/2 "2022-01-13T05:27:12Z")

</div>

You'll probably need to use a script processor in an ingest pipeline to convert that to a proper date. Otherwise Elasticsearch will not accept it.

---

<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:** [January 13, 2022, 5:44am UTC](https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168/3 "2022-01-13T05:44:24Z")

</div>

That looks like a duration and not a date, for which as far as I know there is no native data type. I would therefore recommend transforming it into seconds before ingesting it into Elasticsearch.

---

<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 10, 2022, 5:45am UTC](https://discuss.elastic.co/t/i-cant-ingest-time-longer-than-24-hours/294168/4 "2022-02-10T05:45:07Z")

</div>

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