# Now date with format in \_timestamp

**URL:** <https://discuss.elastic.co/t/now-date-with-format-in--timestamp/22436>\
**Category:** Elasticsearch\
**Created:** [February 27, 2015, 4:50pm UTC](https://discuss.elastic.co/t/now-date-with-format-in--timestamp/22436 "2015-02-27T16:50:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ibailak](https://avatars.discourse-cdn.com/v4/letter/i/dfb087/32.png) [@ibailak](https://discuss.elastic.co/u/ibailak)\
**Post date:** [February 27, 2015, 4:50pm UTC](https://discuss.elastic.co/t/now-date-with-format-in--timestamp/22436/1 "2015-02-27T16:50:44Z")

</div>

I want to index documents with the default value (now date) for the  
\_timestamp, setting this field when elasticsearch indexes the document. I  
would like to save the \_timestamp with a format so later I can use it in  
Kibana. So far I have tried many things, this being the simplest way to try  
to get the desired result:

{  
"mappings": {  
"_default_" : {  
"\_timestamp" : {"enabled" : true, "store" : "yes"}  
}  
}  
}

Is it possible to give to this \_timestamp a format such as "2015-02-25"?

With the actual mapping the value is in epoch timestamp:

fields: {  
\_timestamp: 1424895937428  
}

Even if I don't give the desired format to the \_timestamp, kibana doesn't  
recognize this value, so I can't query by this value.

So far I have also tried using the options like {"format" : "YYYY-MM-dd"}  
or {"index" : "analyzed" } in the mapping but no luck.

Is this that I'm trying even possible?

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/af2bc8ee-2bb2-4ae6-9cef-c6058a9dd078%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/af2bc8ee-2bb2-4ae6-9cef-c6058a9dd078%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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:** [July 6, 2017, 12:29am UTC](https://discuss.elastic.co/t/now-date-with-format-in--timestamp/22436/2 "2017-07-06T00:29:28Z")

</div>