Convert Date time Using StandardTimeZonename instead of Zoneid

Elastic Stack Elasticsearch
1

Hi Team,

I am facing issue to convert Datetime value into their Specific time zone by refering Timezone name from doc.

Scenario:
In my scenario, we have data for different timezones on elastic with thereTimezone belonging field, I want to use full name of TimeZone (attached) instead of using ZoneId like (UTS, PST,CST) to make it dynamic.

In my example, I am able to convert the datetime by passing the sort name of Zone but want to use the full name as we have in the document.

Kindly help me to get the date converted in their mentioned timezone. attached example of one-time zone but we have others as well. like

Hawaiian Standard Time
Alaskan Standard Time
Pacific Standard Time
Mountain Standard Time
Central Standard Time
Eastern Standard Time
West Pacific Standard Time

image
image1647×346 42.8 KB

Thanks for helping.

2

Hi @M.Naim .

I believe that with the StandardTimeZone name it is not possible to find the timezone. The correct is to use the ID.
I don't know if you can perform a reprocessing of the data to index the ZoneId but it would be the most interesting.

3

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