# Kibana 4.1.1 unable to map timestamp which is in UNIX Epoch format
**URL:** https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244
**Category:** Kibana
**Created:** [August 28, 2015, 1:30pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244 "2015-08-28T13:30:19Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@cloud\_admin](https://discuss.elastic.co/u/cloud_admin)
#### Post date: [August 28, 2015, 1:30pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/1 "2015-08-28T13:30:19Z")
Hi Team,
I have recently upgraded my Kibana from 3 to 4.1.1, my nginx access logs has Epoch Time format like 1434589605.318 and kibana is not able to detect this time stamp field, hence I am not able to segregate the logs, however if I try the same access logs on kibana3 it is able to detect timestamp after I mention the filed in Time picker.
Please guide me on how to map this time stamp to index so that I can segregate the logs based on time stamp.
Thanks and Regards,
Naren.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [August 29, 2015, 10:36pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/2 "2015-08-29T22:36:20Z")
What does the mapping in ES look like for that field?
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [September 2, 2015, 3:53am UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/3 "2015-09-02T03:53:45Z")
There is no change in the way Kibana 4 treats timestamps, compared to Kibana 3. Both require that your time field is mapped as a "date" in Elasticsearch.
For reference, here is a sample mapping that works:
```
"@timestamp" : {
"type" : "date",
"format" : "strict_date_optional_time||epoch_millis"
},
```
---
### Author:  [@cloud\_admin](https://discuss.elastic.co/u/cloud_admin)
#### Post date: [September 3, 2015, 7:30pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/4 "2015-09-03T19:30:15Z")
> [@tbragin](#):
>
> "@timestamp" : {
> "type" : "date",
> "format" : "strict\_date\_optional\_time||epoch\_millis"
> },
Thanks for your reply, my kibana4 gets logs from one ES cluster where time format is in epoch format and it is mapped to field "ts", however nothing is being displayed in indices filed
 could you please guide me on where should I map the ts field so that it will populate in Indices
Thanks and Regards,
Narendra.
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [September 10, 2015, 10:32pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/5 "2015-09-10T22:32:33Z")
Could you post your mappings from ES to make sure we're talking about the same thing?
---
### Author:  [@cloud\_admin](https://discuss.elastic.co/u/cloud_admin)
#### Post date: [September 11, 2015, 12:23pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/6 "2015-09-11T12:23:23Z")
Hi Tanya,
Thanks for your reply, below are my mappings.
 
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [September 11, 2015, 1:45pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/7 "2015-09-11T13:45:08Z")
So, I don't see anything with type "date" in there -- that's what you need.
---
### Author:  [@cloud\_admin](https://discuss.elastic.co/u/cloud_admin)
#### Post date: [September 12, 2015, 3:52pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/8 "2015-09-12T15:52:06Z")
The Field TS is the timestamp in epoch format, in kiabna 3 I am able to mention @ts in time picker and it is able to recognise it, however in kibana4 i am not able to map it,
Is there a way to mention it in kibana4 apart from modifying it in elastic search?
---
### Author:  [@derandreasberger](https://discuss.elastic.co/u/derandreasberger)
#### Post date: [December 16, 2015, 3:57pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/9 "2015-12-16T15:57:54Z")
Hello!
I've been struggling with timestamps too. The only way i found to get it to work as i wanted to, was to create a new template for timestamp mapping.
curl -XPUT '[http://YOURELASTICSEARCHSERVER:9200/\_template/indexname\*/](http://YOURELASTICSEARCHSERVER:9200/_template/indexname*/)' -d @elastic\_template.json
content of file "elastic\_template.json"
{
"template": "indexname\*",
"order": 1,
"mappings" : {
"index" : {
"properties" : {
"log\_date" : {
"type" : "date",
"format": "yyyy-MM-dd HH:mm:ss,SSS||yyyy-MM-dd HH:mm:ss.SSS||yyyy/MM/dd HH:mm:ss||yyyy-MM-dd||MMM dd, yyyy HH:mm:ss a"
},
"appname" : {
"type" : "string",
"index": "not\_analyzed"
},
"msg\_content" : {
"type" : "string"
}
}
}
}
}
}
I guess this will work for epoch\_millis as well. Most important thing: Ensure elasticsearch is saving your timestamp as date, check with:
curl -XGET '[http://YOURELASTICSEARCHSERVER:9200/indexname\*/\_mapping?pretty](http://YOURELASTICSEARCHSERVER:9200/indexname*/_mapping?pretty)'
Hope it helps!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:06pm UTC](https://discuss.elastic.co/t/kibana-4-1-1-unable-to-map-timestamp-which-is-in-unix-epoch-format/28244/10 "2017-07-06T14:06:29Z")