# Incorrect local time in "Time" field in discover tab

**URL:** <https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846>\
**Category:** Kibana\
**Created:** [April 20, 2018, 9:55am UTC](https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846 "2018-04-20T09:55:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![roman\_mizilin](https://avatars.discourse-cdn.com/v4/letter/r/977dab/32.png) [@roman\_mizilin](https://discuss.elastic.co/u/roman_mizilin)\
**Post date:** [April 20, 2018, 9:55am UTC](https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846/1 "2018-04-20T09:55:25Z")

</div>

Hi,  
In the discover tab, incorrectly displays the Time field as local time + 03:00. My timezone +03:00. The result is UTC+6.

 ![Kibana](https://us1.discourse-cdn.com/elastic/original/3X/e/5/e5ed329f80e46e233a24b2f8535a07df959717ed.png)

In ES element:

```
  "hits": {
"total": 1,
"max_score": 1,
"hits": [
  {
    "_index": "wl_test",
    "_type": "doc",
    "_id": "0P5W4mIBFyp8pk_kqxjL",
    "_score": 1,
    "_source": {
      "message": "Self-tuning thread pool contains 1 running threads, 400 idle threads, and 56 standby threads",
      "@version": "1",
      "Time": "2018-04-20 12:15:53",
      "Thread": "Timer-2",
      "@timestamp": "2018-04-20T09:15:53.000Z",
      "timestamp": "1524215753.571",
      "source_host": "ip_host",
      "level": "6",
      "SourceMethodName": "log",
      "LoggerName": "WorkManager",
      "host": "hostname",
      "SourceSimpleClassName": "BaseLogger",
      "SourceClassName": "com.bea.logging.BaseLogger",
      "Severity": "Info"
    },
    "fields": {
      "Time": [
        "2018-04-20T12:15:53.000Z"
      ]
    }
  }
]

```

}  
}

Logstash configuration:  
input {  
gelf {  
port =\> "12201"  
type =\> "gelf"  
}  
}  
filter {  
mutate {  
gsub =\> ["Time", ",\d\d\d\d$", ""]  
remove\_field =\> ["facility", "MessageParam0", "MessageParam1", "MessageParam2", "MessageParam3", "MessageParam4", "type"]  
}  
date {  
match =\> ["Time", "yyyy-MM-dd HH:mm:ss"]  
timezone =\> "Europe/Moscow"  
}  
}  
output {  
elasticsearch {  
hosts =\> ["host1:9200","host2:9200","host3:9200"]  
index =\> "wl\_test"  
manage\_template =\> false  
}  
}

Mapping field Time in wl\_test index:  
"Time": {  
"type": "date",  
"fields": {  
"keyword": {  
"type": "keyword",  
"ignore\_above": 256  
}  
},  
"format": "yyyy-MM-dd HH:mm:ss"  
}

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [April 20, 2018, 2:56pm UTC](https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846/2 "2018-04-20T14:56:30Z")

</div>

What is your system timezone? Is the data getting stored in Elasticsearch with the correct values? I see that Time has a value of 2018-04-20 12:15:53 and @timestamp has a value of 2018-04-20T09:15:53.000Z. What is the correct value?

How is kibana configured to handle time zones? Under `management -> advance settings` What is the value of `dateFormat:tz`?

---

<div class="post-metadata">

**Author:** ![roman\_mizilin](https://avatars.discourse-cdn.com/v4/letter/r/977dab/32.png) [@roman\_mizilin](https://discuss.elastic.co/u/roman_mizilin)\
**Post date:** [April 20, 2018, 7:43pm UTC](https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846/3 "2018-04-20T19:43:40Z")

</div>

1. System timezone = "Europe/Moscow" (UTC+3)
2. Correct value is 2018-04-20 12:15:53, this value corresponds to my timezone.
3. In Elasticsearch correct values, but I have a doubt about doc\_values field:  
"fields": {  
"Time": [  
"2018-04-20T12:15:53.000Z"  
]  
}  
time in my timezone with Z end (UTC)
4. Kibana timezone selected Browser ( this corresponds to my timezone)

---

<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:** [May 18, 2018, 7:43pm UTC](https://discuss.elastic.co/t/incorrect-local-time-in-time-field-in-discover-tab/128846/4 "2018-05-18T19:43:59Z")

</div>

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