Elasticsearch 6.2 - how to format date (epoch) field in yyyymm string in painless inline scripting

Question

In Elasticsearch 6.2, I have an index where there are two timestamp fields as follows:

"start_ts":  { "type": "date", "format": "epoch_second"  },                       
"end_ts":    { "type": "date", "format": "epoch_second"  }

In my painless inline script, for some calculation, I want to convert them (doc["start_ts"] and doc["end_ts"]) to this string format (yyyymm). Any idea how can it be done? I could not find any documentation for formatting in ES official documentation.

Take a look at the answer if this question: https://stackoverflow.com/questions/45864201/elasticsearch-painless-manipulate-date — Mohammad Mazraeh, Jun 09 '18 at 13:51

score 1 · Answer 1 · edited Mar 31 '19 at 22:29

1

doc["end_ts"].toString("yyyyMM")

edited Mar 31 '19 at 22:29

Pika Supports Ukraine

3,612
10
26
42

answered Mar 31 '19 at 22:28

Shoukry

59
2

score 0 · Answer 2 · edited Jul 08 '22 at 22:02

0

If the above answer doesn't work, just add .value to it. i.e,

doc["end_ts"].value.toString("yyyyMM")

edited Jul 08 '22 at 22:02

buddemat

4,552
14
29
49

answered Jul 07 '22 at 15:49

Sahil Shah

1

Welcome to SO! JYou shouldn't refer to another answer as "above", since it's not sure that it will be displayed above. Instead, include the necessary information in your post. – buddemat Jul 08 '22 at 22:04

Elasticsearch 6.2 - how to format date (epoch) field in yyyymm string in painless inline scripting

2 Answers2