https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339792#M100788 <P>You welcome! (:</P> Tue, 17 Apr 2018 16:07:17 GMT damien_chillet 2018-04-17T16:07:17Z https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339789#M100785 <P>Hi, I have a simple search that brings up the total count of logons in a day but I want the time part to say April,16,17,18 and so on instead of 2018-04-16 00:00:00. How can one achieve that?</P> <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/4775iF778E63ADB1E6B0E/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Tue, 17 Apr 2018 15:46:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339789#M100785 carlyleadmin 2018-04-17T15:46:09Z https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339790#M100786 <P>Add the following at the end of your search:</P> <PRE><CODE>| convert timeformat="%B %d" ctime(_time) </CODE></PRE> Tue, 17 Apr 2018 15:52:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339790#M100786 damien_chillet 2018-04-17T15:52:30Z https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339791#M100787 <P>Thanks Damien for the quick response. works like a charm</P> Tue, 17 Apr 2018 16:01:40 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339791#M100787 carlyleadmin 2018-04-17T16:01:40Z https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339792#M100788 <P>You welcome! (:</P> Tue, 17 Apr 2018 16:07:17 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-time-in-string-format/m-p/339792#M100788 damien_chillet 2018-04-17T16:07:17Z