# Time in a field of type date

**URL:** <https://discuss.elastic.co/t/time-in-a-field-of-type-date/247221>\
**Category:** Elasticsearch\
**Created:** [September 2, 2020, 11:39am UTC](https://discuss.elastic.co/t/time-in-a-field-of-type-date/247221 "2020-09-02T11:39:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex9](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex9/32/72742_2.png) [@Alex9](https://discuss.elastic.co/u/Alex9)\
**Post date:** [September 2, 2020, 11:39am UTC](https://discuss.elastic.co/t/time-in-a-field-of-type-date/247221/1 "2020-09-02T11:39:15Z")

</div>

Good day 🙂  
Please tell me how to set up the field correctly so that the time in it does not differ from the incoming data?

```auto
PUT service100
{
  "mappings": {
    "properties": {
      "DELIVERY_TIME": {
        "type": "date",
        "format": "dd/MM/yyyy HH:mm:ss"
      }
      }
  }
}
GET service100/_mapping
PUT service100/_doc/123
{
  "DELIVERY_TIME": "26/05/2020 11:59:58"
}
GET service100/_doc/123

```

 ![Annotation 2020-09-02 143054](https://us1.discourse-cdn.com/elastic/original/3X/5/3/538b6291b430c2906b28288f843294dd4044c657.png)

In kibana, I get 3 hours more time in the field.  
(I suspect it's my time zone ... +3 hours)

I changed the "Timezone for date formatting" parameter in Advanced Settings Kibana from "Browser" to Етс / GMT + 0, but then I get the wrong time (minus three hours) in the @timestamp field, when I import data into the index...

**Thanks in advance everyone for the answer!**

---

<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:** [September 2, 2020, 10:33pm UTC](https://discuss.elastic.co/t/time-in-a-field-of-type-date/247221/2 "2020-09-02T22:33:07Z")

</div>

When Elasticsearch receives a timestamp, it assumes that it is in UTC.  
When you see the document in Kibana's Discover, it's converting that from what Elasticsearch sends it, which again is considered to be UTC, and then converts that into the timezone of the browser.

TLDR, if the timestamp you are not inputting into Elasticsearch is actually in UTC, you will want to adjust it accordingly, and/or change your format to include a timezone so that Elasticsearch can adjust it for you.

---

<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:** [September 30, 2020, 10:33pm UTC](https://discuss.elastic.co/t/time-in-a-field-of-type-date/247221/3 "2020-09-30T22:33:22Z")

</div>

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