https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60974#M180144 <P>How to convert the date and time in the below format to epoch time?<BR /> 201303140216<BR /> yyyymmddHHMM<BR /> here hour and minute is in 12 hours clock, so the time may be 02:16PM<BR /> tried converting it using <BR /> time=strptime(mytime,"%Y%m%d%I%M") <BR /> not seems to be working properly...<BR /> please help<BR /> Thank You</P> Thu, 14 Mar 2013 10:12:32 GMT smolcj 2013-03-14T10:12:32Z https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60974#M180144 <P>How to convert the date and time in the below format to epoch time?<BR /> 201303140216<BR /> yyyymmddHHMM<BR /> here hour and minute is in 12 hours clock, so the time may be 02:16PM<BR /> tried converting it using <BR /> time=strptime(mytime,"%Y%m%d%I%M") <BR /> not seems to be working properly...<BR /> please help<BR /> Thank You</P> Thu, 14 Mar 2013 10:12:32 GMT https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60974#M180144 smolcj 2013-03-14T10:12:32Z https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60975#M180145 <P>If your time is on a 12-hour clock you will need to list AM or PM in your date string, and read that into strptime with %p, without that the hour is ambiguous.</P> Thu, 14 Mar 2013 10:47:22 GMT https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60975#M180145 martin_mueller 2013-03-14T10:47:22Z https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60976#M180146 <P>unfortunately i dont have AM or PM specification in the field <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P> Thu, 14 Mar 2013 11:03:46 GMT https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60976#M180146 smolcj 2013-03-14T11:03:46Z https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60977#M180147 <P>How do you expect the conversion to epoch to work then? Guessing?</P> <P>If you have sufficient data <EM>and</EM> a known starting point you could extrapolate AM/PM over a stream of events based on the rollover from 11 to 12, flipping the A/P every time - that's not robust though.</P> Thu, 14 Mar 2013 11:37:11 GMT https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60977#M180147 martin_mueller 2013-03-14T11:37:11Z https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60978#M180148 <P>Thanks martin.. I think I have to search some other field for sorting.. Thank you for your help .</P> Fri, 15 Mar 2013 04:23:38 GMT https://community.splunk.com/t5/Splunk-Search/convert-date-time-to-epoch-time-for-sorting/m-p/60978#M180148 smolcj 2013-03-15T04:23:38Z