CODEWITHSUNDEEP
elasticsearch
Jacob
Jacob

Reputation: 1896

Format reading ElasticSearch dates

This is my mapping for one of the properties in my ElasticSearch model:

"timestamp":{
  "type":"date",
  "format":"dd-MM-yyyy||yyyy-MM-dd'T'HH:mm:ss.SSSZ||epoch_millis"
}

I'm not sure if I'm misunderstanding the documentation. It clearly says:

The first format will also act as the one that converts back from milliseconds to a string representation.

And that is exactly what I want. I would like to be able to read directly (if possible) the dates as dd-MM-yyyy.

Unfortunately, when I go to the document itself (so, accessing to the ElasticSearch's endpoint directly, not via the application layer) I still get:

"timestamp" : "2014-01-13T15:48:25.000Z",

What am I missing here?.

Upvotes: 0

Views: 68

Answers (1)

Kamal Kunjapur
Kamal Kunjapur

Reputation: 8860

As @Val mentioned, you'd get the value/format as how it is being indexed.

However if you want to view the date in particular format regardless of the format it has been indexed, you can make use of Script Fields. Note that it would be applied at querying time.

Below query is what your solution would be. 

POST <your_index_name>/_search
{
  "query":{
    "match_all":{ }
  },
  "script_fields":{
    "timestamp":{
       "script":{
         "inline": "def sf = new SimpleDateFormat(\"dd-MM-yyyy\");def dt = new Date(doc['timestamp'].value);def mydate = sf.format(dt);return mydate;"
       }
    }
  }
}

Let me know how it goes.

Upvotes: 1

Related Questions