# Elastic Date field Retrieval Issue **URL:** \ **Category:** Elasticsearch\ **Created:** [July 8, 2017, 12:37pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360 "2017-07-08T12:37:15Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 8, 2017, 12:37pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/1 "2017-07-08T12:37:15Z")
Hi, Is it possible to have custom format for date field store and retrieval so that both the way elastic and java api level will be uniform date. Now we are facing date field binding to application object date property. As Elastic Date Format Will joda application date will be java util date. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 8, 2017, 4:01pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/2 "2017-07-08T16:01:48Z")
Not sure I understand but may be date ingest processor is what you want. ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 11, 2017, 5:05pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/3 "2017-07-11T17:05:33Z")
Hi, Is there any way to specify or inform elastic to return date in dd-mm-yyyy hh:mm:dd format java.util.date format ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 11, 2017, 6:11pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/4 "2017-07-11T18:11:45Z")
With which API? ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 12, 2017, 2:16am UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/5 "2017-07-12T02:16:14Z")
Java elastic api. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 12, 2017, 2:38am UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/6 "2017-07-12T02:38:27Z")
Which API of the Java API? - When you do a GET index/type/id? - When you do a \_search? - In the resultset in \_source? - In the result of aggregations? - ... ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 12, 2017, 9:55am UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/7 "2017-07-12T09:55:48Z")
hi, In Any of the java elastic api Like Get. the resultant hits field i wanted date filed as custom formatted like dd:mm:yy hh:mm:ss ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 12, 2017, 10:59am UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/8 "2017-07-12T10:59:25Z")
You will get back what you sent. Elasticsearch just reads the \_source field which contains your json document as is. ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 12, 2017, 12:17pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/9 "2017-07-12T12:17:06Z")
Hi, There is any option to store date field in specific format. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 12, 2017, 12:32pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/10 "2017-07-12T12:32:14Z")
I think you did not understand what I said. If you send a date like: ```auto { "date": "10/01/2017" } ``` You will get it back as: ```auto { "date": "10/01/2017" } ``` If you send it as: ```auto { "date": "2017-01-10" } ``` You will get it bas as: ```auto { "date": "2017-01-10" } ``` So it's up to you to send it in the format you expect to find it later. ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 12, 2017, 12:40pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/11 "2017-07-12T12:40:37Z")
hi, But always it is stored and retrieved as dd-mm-yyThh:mm:ss ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 12, 2017, 12:43pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/12 "2017-07-12T12:43:20Z")
Why do you send it as `dd-mm-yyThh:mm:ss`? ---
**Author:** ![Hoffin\_Ag](https://avatars.discourse-cdn.com/v4/letter/h/ba8739/32.png) [@Hoffin\_Ag](https://discuss.elastic.co/u/Hoffin_Ag)\ **Post date:** [July 12, 2017, 12:47pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/13 "2017-07-12T12:47:34Z")
Hi , We are using the logstash jdbc input. i also specified the date format to custom format. but still in elastic stored as dd-mm-yyThh:mm:ss this format. and also i mentioned the date field mapping in elasticsearch as field : trn\_date format : dd:mm:yy this format will not used to convert the incoming date data? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 12, 2017, 12:51pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/14 "2017-07-12T12:51:00Z")
The format is used to parse what you sent as a String to a Date object. Then what is "stored" in the \_source is what you sent in the original format. Elasticsearch does not modify the `_source` field (unless you are using node ingest feature). > We are using the logstash jdbc input. That's a new information. So probably that's how logstash is reading the data from the database. But I'd ask this in #logstash forum instead. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 9, 2017, 12:51pm UTC](https://discuss.elastic.co/t/elastic-date-field-retrieval-issue/92360/15 "2017-08-09T12:51:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.