Is there a way to convert a date field into a different timezone using Painless language?

Question

Is there a way to convert this code using Painless? the index have a field named created, and the goal is to convert the value to a different timezone, currently it's in UTC.

  "aggregations": {
    "dayOfWeek": {
      "terms": {
        "script": {
          "inline": "doc['created'].date.setZone(org.joda.time.DateTimeZone.forID(tz)); doc['created'].date.dayOfWeek",
          "lang": "groovy",
          "params": {
            "tz": "Europe/London"
          }
        }
      }
    }
  }

Is it working or not? Do you get any errors when running this? — Mysterion, Jan 16 '19 at 15:07
I think it's working.I don't have *groovy* installed, I only have *painless*. So I'm trying to find a way to do this using *painless*. — Jane S., Jan 16 '19 at 15:17

score 2 · Answer 1 · answered Mar 30 '20 at 17:05

2

after a long long search on google for my own need. This works for me (using painless):

def myDate = doc['created'].value.withZoneSameInstant(ZoneId.of('Europe/London')); 
myDate.dayOfWeek;

I found help on this page: https://gitlab.kveer.fr/upstream/elasticsearch/commit/81f60652d8c4763b3470d148239c96bcd0c29553

answered Mar 30 '20 at 17:05

Mikael B

21
2

Awesome! This made my day .. was looking for that for a few days already and finally his snippet worked! Thanks. – Andy Feb 16 '22 at 15:40

Is there a way to convert a date field into a different timezone using Painless language?

1 Answers1