将UTC转换为PST的Elasticsearch查询

GET /my_index/_search
{
  "query": {
    "range": {
      "timestamp": {
        "gte": "2022-01-01T00:00:00Z",
        "lte": "2022-01-01T23:59:59Z"
      }
    }
  }
}

GET /my_index/_search
{
  "query": {
    "range": {
      "timestamp": {
        "gte": "2022-01-01T00:00:00Z",
        "lte": "2022-01-01T23:59:59Z"
      }
    }
  },
  "script_fields": {
    "pst_time": {
      "script": {
        "source": "doc['timestamp'].value.withZoneSameInstant(ZoneId.of('America/Los_Angeles')).toString()"
      }
    }
  }
}