# Date field timezone

**URL:** <https://discuss.elastic.co/t/date-field-timezone/146947>\
**Category:** Elasticsearch\
**Created:** [September 1, 2018, 5:12pm UTC](https://discuss.elastic.co/t/date-field-timezone/146947 "2018-09-01T17:12:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![oms1226](https://avatars.discourse-cdn.com/v4/letter/o/c57346/32.png) [@oms1226](https://discuss.elastic.co/u/oms1226)\
**Post date:** [September 1, 2018, 5:12pm UTC](https://discuss.elastic.co/t/date-field-timezone/146947/1 "2018-09-01T17:12:22Z")

</div>

I don't use @timestamp. but I have own date-type field. The field name is execTime.  
my datas only upload under offline.  
For example, all the datas move to elastic server using USB memory and so on.  
Recently I found the different between execTime value in kibana and in memory.  
The cause is date field's timezone. The problem is solved using timezone setting in logstash.config.  
ex.  
date {  
match =\> ["execTime", "yyyyMMddHHmm", "yyyyMMddHHmmss", "yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm:ss.SSS"]  
timezone =\> "Asia/Seoul"  
target =\> "execTime"  
}  
However, I found another problem.  
The execTime is celular's local time. so timezone is various.  
I want to set the date field considering different timezone.  
I need your help.

---

<div class="post-metadata">

**Author:** ![tamara](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tamara/32/47095_2.png) [@tamara](https://discuss.elastic.co/u/tamara)\
**Post date:** [September 4, 2018, 8:38am UTC](https://discuss.elastic.co/t/date-field-timezone/146947/2 "2018-09-04T08:38:13Z")

</div>

In order to be considered the timezone you need to make sure the field execTime has the timezone information in it, otherwise it will use the timezone that you defined at [Date timezone](https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html#plugins-filters-date-timezone).

In this thread [How to set @timestamp timezone?](https://discuss.elastic.co/t/how-to-set-timestamp-timezone/28401/2) you can read a discussion about Logstash and Kibana timezone. It is suggested to convert all the timestamps in the UTC timezone.

Hope I could help 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:** [October 2, 2018, 8:38am UTC](https://discuss.elastic.co/t/date-field-timezone/146947/3 "2018-10-02T08:38:14Z")

</div>

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