# Can unix timestamp be used as field in date histogram?

**URL:** <https://discuss.elastic.co/t/can-unix-timestamp-be-used-as-field-in-date-histogram/8356>\
**Category:** Elasticsearch\
**Created:** [July 9, 2012, 9:32am UTC](https://discuss.elastic.co/t/can-unix-timestamp-be-used-as-field-in-date-histogram/8356 "2012-07-09T09:32:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![komaln](https://avatars.discourse-cdn.com/v4/letter/k/8797f3/32.png) [@komaln](https://discuss.elastic.co/u/komaln)\
**Post date:** [July 9, 2012, 9:32am UTC](https://discuss.elastic.co/t/can-unix-timestamp-be-used-as-field-in-date-histogram/8356/1 "2012-07-09T09:32:45Z")

</div>

Hi,

I am building a log analysis tool and want to create the timeline series graph of the number of log entries logged.

I wish to use the date histogram feature for it. A query like:  
"facets" : {  
"histo1" : {  
"date\_histogram" : {  
"field" : "field\_name",  
"interval" : "day"  
}  
}  
}  
would work just fine for me. I dont have any field in the "date" format, so I was wondering if I can use the unix timestamp field I have indexed in my elasticsearch for the same purpose. Its a date in different format.

I tried a couple of things myself, didnt work. Can you please suggest?

Thanks and Regards,  
Komal.

---

<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, 3:20am UTC](https://discuss.elastic.co/t/can-unix-timestamp-be-used-as-field-in-date-histogram/8356/2 "2017-07-06T03:20:59Z")

</div>