# Getting different @timestamp field in kibana as a JSON document and in Table

**URL:** <https://discuss.elastic.co/t/getting-different-timestamp-field-in-kibana-as-a-json-document-and-in-table/177399>\
**Category:** Kibana\
**Created:** [April 18, 2019, 5:14am UTC](https://discuss.elastic.co/t/getting-different-timestamp-field-in-kibana-as-a-json-document-and-in-table/177399 "2019-04-18T05:14:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\
**Post date:** [April 18, 2019, 5:14am UTC](https://discuss.elastic.co/t/getting-different-timestamp-field-in-kibana-as-a-json-document-and-in-table/177399/1 "2019-04-18T05:14:12Z")

</div>

Hello,

My filebeat (data Server ) is in IST Zone and my Elastic timezone is also IST.  
When i am parsing the logs .  
according to my use case I provided dynamic mapping to my index and my dynamic mapping is

PUT /requestme  
{  
"settings" : {  
"index" : {  
"number\_of\_shards" : 2,  
"number\_of\_replicas" : 0  
}  
},  
"mappings": {  
"doc": {  
"date\_detection": true,

```
 "properties": {
    "created": { "type": "date",
    "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis"
    }
 },
 "dynamic_templates": [
   {
     "integers": {
       "match_mapping_type": "long",
       "mapping": {
         "type": "integer"
       }
     }
   },
   {
     "strings": {
       "match_mapping_type": "string",
       "mapping": {
         "type": "keyword"
           }
         }
       }
 ]

```

}  
}  
}

and according to my use case I am having a received field in my logs and I renamed it to a created field and mapped to @timestamp field in logstash

date {  
match =\> ["created", "yyyy-MM-dd HH:mm:ss"]  
timezone =\> "UTC"  
target =\> "@timestamp"  
}

Now I am getting different time for the same log in Kibana as a JSON and as a table

Please find the screenshot below for both  
as you can see that JSON time for the created and @timestamp in JSON is different as compared to table in both screenshot and I in JSON the created field time is the real time of the log.

Please help me to clear the doubt and solve this issue

 ![IMG_20190418_103435](https://us1.discourse-cdn.com/elastic/original/3X/8/4/84a671d913e0b600d84a2b0f0504b2429f1729a8.jpeg) ![IMG_20190418_102725](https://us1.discourse-cdn.com/elastic/original/3X/6/0/603c6fdb5543944bf4762db78be2a4db01a466ba.jpeg)

---

<div class="post-metadata">

**Author:** ![Divit\_Sharma](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/divit_sharma/32/32348_2.png) [@Divit\_Sharma](https://discuss.elastic.co/u/Divit_Sharma)\
**Post date:** [April 18, 2019, 5:32am UTC](https://discuss.elastic.co/t/getting-different-timestamp-field-in-kibana-as-a-json-document-and-in-table/177399/2 "2019-04-18T05:32:45Z")

</div>

I think it's correct. The json is showing you time in utc and what is stored in elasticsearch. But the table/discover which is kibana converts that utc time to ist as per your browser timezone.

To confirm this check that the discover/table time will be 5 hours 30 minutes ahead

---

<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 16, 2019, 5:32am UTC](https://discuss.elastic.co/t/getting-different-timestamp-field-in-kibana-as-a-json-document-and-in-table/177399/3 "2019-05-16T05:32:47Z")

</div>

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