Splunk Search

convert date to readable format

katesplunk
Explorer

Experts,
Time of the log is appended in my source file name ... I want it to be converted into a human readable format and i prefer assigning the same to a field . lets say new_time.. Hope u can help me...
Sample file name
...... 20130124 ......... file.txt
...... 20121229.......... file.txt
Thanks
Katrine

Tags (2)
0 Karma

yannK
Splunk Employee
Splunk Employee

first, extract the date from the source.

source=*mysource* | rex field=source "(?<_date_>\d{8})" | table _date_

see http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Rex

second convert the date using your format of choice .
mysearch | convert TIMEFORMAT="%Y-%m-%d" ctime(_date_) AS date

see http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Convert

smolcj
Builder

have the same query, but i dont want it to be in readable format as i am using this time for sorting my field entries..
How to convert the date in the above format to epoch time?
201303140216
yyyymmddHHMM
here hour and minute is in 12 hours clock, so the time may be 02:16PM
tried converting it using
time=strptime(mytime,"%Y%m%d%I%M")
not seems to be working properly...
please help

0 Karma

Drainy
Champion

What did you try exactly?

katesplunk
Explorer

date is in the format yyyymmdd so output should be 24-01-2013.. but result obtained is something else.. tried changing time date variables

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...