How to format date inside source script?

Question

I'm using terms aggregations with script property, i know that i can use format property to get date value in specific date format; but i wanna write required format to be gotten inside script source code.

{
  "size": 0,
  "aggs": {
    "NAME": {
      "terms": {
        "script": {
          "source": "doc['Ship Date'].value",
          "lang": "painless"
        },
        "size": 100,
        "order": {
          "_key": "asc"
        }
      }
    }
  }
}

jaspreet chahal · Accepted Answer · 2019-09-30 06:10:24Z

2

You can do something like below

"size": 0,
  "aggs": {
    "NAME": {
      "terms": {
        "script": {
          "source": "String datetime = 'Thu, 13 Oct 1983 22:15:30 GMT';ZonedDateTime zdt = ZonedDateTime.parse(datetime,DateTimeFormatter.RFC_1123_DATE_TIME); return zdt ",
          "lang": "painless"
        },
        "size": 100,
        "order": {
          "_key": "asc"
        }
      }
    }
  }

You can parse different formats to ZonedDateTime.parse() You can get full detail here

answered Sep 30, 2019 at 6:10

jaspreet chahal

9,1492 gold badges14 silver badges30 bronze badges

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

1 Comment

jaspreet chahal Over a year ago

Glad could be of help.

Collectives™ on Stack Overflow

How to format date inside source script?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related