https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439892#M125129 <P>There are no direct function available to do so , but you can try workarounds provided in this post: <A href="https://answers.splunk.com/answers/241917/timezone-conversion-function.html">https://answers.splunk.com/answers/241917/timezone-conversion-function.html</A></P> Mon, 22 Oct 2018 14:00:39 GMT somesoni2 2018-10-22T14:00:39Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439891#M125128 <P>Hi,</P> <P>I have a field named "statusChanged" as shown below. I need to convert this (GMT) to EST . please help on the same.</P> <P>statusChanged: 2018-10-17T15:29:32.000Z </P> Mon, 22 Oct 2018 09:40:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439891#M125128 abhi04 2018-10-22T09:40:41Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439892#M125129 <P>There are no direct function available to do so , but you can try workarounds provided in this post: <A href="https://answers.splunk.com/answers/241917/timezone-conversion-function.html">https://answers.splunk.com/answers/241917/timezone-conversion-function.html</A></P> Mon, 22 Oct 2018 14:00:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439892#M125129 somesoni2 2018-10-22T14:00:39Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439893#M125130 <P>@somesoni2 The below worked .</P> <P>eval EST_Time=strftime(strptime(statusChanged,"%Y-%m-%dT%H:%M:%S.%3N%Z"),"%Y-%m-%d %H:%M:%S")</P> Mon, 22 Oct 2018 15:47:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439893#M125130 abhi04 2018-10-22T15:47:28Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439894#M125131 <P>eval EST_Time=strftime(strptime(statusChanged,"%Y-%m-%dT%H:%M:%S.%3N%Z"),"%Y-%m-%d %H:%M:%S")</P> Tue, 23 Oct 2018 07:50:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-the-GMT-timezone-to-EST-timezone-at-search-time/m-p/439894#M125131 abhi04 2018-10-23T07:50:27Z