# Elasticsearch date format am pm

**URL:** https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470
**Category:** Elasticsearch
**Created:** [August 27, 2017, 8:05am UTC](https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470 "2017-08-27T08:05:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![svarup](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@svarup](https://discuss.elastic.co/u/svarup)
#### Post date: [August 27, 2017, 8:05am UTC](https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470/1 "2017-08-27T08:05:09Z")

</div>

In elasticsearch how to index a doc with date format 2017-08-27 01:34:15 PM

---

<div class="post-metadata">

### Author: ![svarup](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@svarup](https://discuss.elastic.co/u/svarup)
#### Post date: [August 27, 2017, 8:51am UTC](https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470/2 "2017-08-27T08:51:03Z")

</div>

i think we have to store the date in 24 hours Y-m-d\TH:i:s (PHP format) format and for display, we use our programing language(PHP) to convert 24 hours to 12 hours with am or pm.

---

<div class="post-metadata">

### Author: ![ahmadimt07](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmadimt07/32/10031_2.png) [@ahmadimt07](https://discuss.elastic.co/u/ahmadimt07)
#### Post date: [August 27, 2017, 2:41pm UTC](https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470/3 "2017-08-27T14:41:01Z")

</div>

You can refer to the [documentation](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html#custom-date-formats) for in built date format supported by ES.

Also, if none of the in built formats is suitable for you, then you can create a custom date format. It follows the Joda time date format. You can find that [here](http://www.joda.org/joda-time/apidocs/org/joda/time/format/DateTimeFormat.html)

---

<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: [September 24, 2017, 2:41pm UTC](https://discuss.elastic.co/t/elasticsearch-date-format-am-pm/98470/4 "2017-09-24T14:41:22Z")

</div>

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