https://community.splunk.com/t5/Getting-Data-In/Timestamp-conversion-to-epoch-time/m-p/167282#M33859 <P>I have a timestamp in the format "19-06-2015 07:00:00 Europe/London". Is there a way to convert this timestamp to epoch time using timestamp conversion function?</P> <P>I am having this column in data as T_BST. I have tried converting it using query "| convert timeformat="%d-%m-%Y %H:%M:%S %Z" mktime(T_BST) as T_BSTE" but it is not getting converted and giving result as blank.</P> <P>Please suggest.</P> Mon, 28 Sep 2020 20:19:20 GMT AditiKulkarni 2020-09-28T20:19:20Z https://community.splunk.com/t5/Getting-Data-In/Timestamp-conversion-to-epoch-time/m-p/167282#M33859 <P>I have a timestamp in the format "19-06-2015 07:00:00 Europe/London". Is there a way to convert this timestamp to epoch time using timestamp conversion function?</P> <P>I am having this column in data as T_BST. I have tried converting it using query "| convert timeformat="%d-%m-%Y %H:%M:%S %Z" mktime(T_BST) as T_BSTE" but it is not getting converted and giving result as blank.</P> <P>Please suggest.</P> Mon, 28 Sep 2020 20:19:20 GMT https://community.splunk.com/t5/Getting-Data-In/Timestamp-conversion-to-epoch-time/m-p/167282#M33859 AditiKulkarni 2020-09-28T20:19:20Z https://community.splunk.com/t5/Getting-Data-In/Timestamp-conversion-to-epoch-time/m-p/167283#M33860 <P>Use <STRONG>strptime</STRONG> command: <A href="http://docs.splunk.com/Documentation/Splunk/6.2.3/SearchReference/Commontimeformatvariables">http://docs.splunk.com/Documentation/Splunk/6.2.3/SearchReference/Commontimeformatvariables</A></P> <P>Thanks!!!</P> Fri, 19 Jun 2015 08:16:31 GMT https://community.splunk.com/t5/Getting-Data-In/Timestamp-conversion-to-epoch-time/m-p/167283#M33860 vganjare 2015-06-19T08:16:31Z