I am query elasticsearch in my pipeline for a date/time field. Elasticsearch stores those date/time fields in UTC time, regardless of of the timezone they were ingested in. Is it possible to convert the time to local time? Alternatively, can I take a local time value and convert it to utc? I'm u…

How do I do that? I see in the documentation I would use the time_zone parameter but where and how exactly? Do I have to use a query template or can I stick to using a query string?

There is an example in the documentation . I do not think you are forced to use a template.

Wait, let me back up, I think I went down the wrong rabbit hole. I am performing an elasticsearch query looking for a ticket number, say abc123. If that ticket number is found, then give me the field, updated_on, which is a date field stored in UTC time. My understanding of what you are saying fo…

Here's my query config, if it helps: elasticsearch { hosts => ["https://fqdn:9200"] #The number field has an alphanumeric value. query => "number:%{number}" index => "servicenow-*" #The sys_updated_on field has a date/time value. fields => { "sys_updated_on" => "[old][sys_up…

Oh, right. In that case I would mutate+convert it to a string and run it through a date filter with a timezone option. It's not elegant, but it should work.

The value returned by elasticsearch is a date/time string, so I can't directly convert it (When I do, all I get is 2019). I can pass it to the date filter to convert it to a date/time object, then run a ruby code that converts it to unix time, but I'm still 5-6 hours off, depending on daylight savi…

Strip off the Z with mutate+gsub before passing to a date filter with a timezone option?

Convert Elasticsearch Date/Time field from UTC To Local Time

Elastic Stack Logstash

Badger July 17, 2019, 6:14pm 2

Tell elasticsearch what timezone you want the results to be in as part of the query?

Topic		Replies	Views
Convert Elasticsearch Date/Time field from UTC To Local Time? Elasticsearch	10	20312	October 4, 2021
Convert the default ES UTC time to local timezone with logstash Logstash	11	320	June 25, 2024
Timezone in ES Python Client Elasticsearch	2	2345	February 9, 2018
Converty query result's datetime accroding to timezone in Elasticsearch Elasticsearch	1	512	August 9, 2018
How do i change time in elasticsearch result according to local timezone? Elasticsearch	1	473	October 4, 2018

Convert Elasticsearch Date/Time field from UTC To Local Time

Related topics