https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248452#M74159 <P>Try this</P> <PRE><CODE>... | eval t=strptime(timestamp. "%Y-%m-%dT%H:%M:%S") </CODE></PRE> Fri, 26 Aug 2016 16:49:25 GMT sundareshr 2016-08-26T16:49:25Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248451#M74158 <P>Hi <BR /> I have a timestamp field with values as below </P> <P>"2016-08-25T13:30:36.82" <BR /> "2016-08-25T13:13:38.737"<BR /> "2016-08-25T11:05:32.76"</P> <P>How i can convert this into the epoch time so that i can use the value to compare with other epoch value. </P> <P>Your help will be greatly appreaciated. </P> Fri, 26 Aug 2016 16:34:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248451#M74158 samarkumar 2016-08-26T16:34:56Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248452#M74159 <P>Try this</P> <PRE><CODE>... | eval t=strptime(timestamp. "%Y-%m-%dT%H:%M:%S") </CODE></PRE> Fri, 26 Aug 2016 16:49:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248452#M74159 sundareshr 2016-08-26T16:49:25Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248453#M74160 <P>I had a discussion with Sundaresh, and i tried below thing and it works as expected. </P> <P>..|eval t=strptime(timestamp, "\"%Y-%m-%dT%H:%M:%S")|..</P> <P>Thank You.</P> Fri, 26 Aug 2016 18:11:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-time-into-the-Epoch-format/m-p/248453#M74160 samarkumar 2016-08-26T18:11:33Z