Format reading ElasticSearch dates

Question

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?.

what you get back is what you store in the source, ES will never modify the source document you're sending to it, unless you configure an ingestion pipeline to make some modifications. The format is used by ES in order to know how to interpret and index your data. — Val
– Val, Commented Nov 16, 2018 at 11:52

Kamal Kunjapur · Accepted Answer · 2018-11-16 12:53:08Z

1

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.

edited Nov 16, 2018 at 12:53

answered Nov 16, 2018 at 12:48

Kamal Kunjapur

8,9182 gold badges26 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kamal Kunjapur Over a year ago

Any luck with the above query? Does it fulfil your requirement?

Jacob Over a year ago

It does @Kamal thank you!. Not completely satisfied with the fact that it has to be specified for every query and I cannot decide something like a default format, but I understand now why that is. Thanks a lot.

Collectives™ on Stack Overflow

Format reading ElasticSearch dates

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related