Date histogram ignores timezone

I have date field "local_time": "2020-04-10T23:00:52.000-0600" which stores the local time (various timezones).
Now I want to use date_histogram to group data by day but it auto converts the above time to UTC and it will be grouped to 11 April, which is not really correct for me. Because there are many other timezones so I want to group them in the same day in local time.

Client can send all the timezones id but I don't know how to apply to the param timezone in date_histogram because there are more than 1.

Is there any way to achieve this?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.