Splunk Search

How to extract date YYYYMMDD from _time?

royimad
Builder

How to extract date YYYYMMDD from _time?

Tags (1)
1 Solution

Damien_Dallimor
Ultra Champion
... | eval mytime=strftime(_time, "%Y%m%d") | table mytime

View solution in original post

nandipatisunil
Path Finder

How do i get this treated as date again?
I was using the above eval to get just the date out (ignoring the time) ... but i see that the string extracted is treated as a number when i graph it.

How do i get it converted back to date?

eg: i have events with different timestamp and the same date. I want to group them based on the date by ignoring the timestamp on it.

0 Karma

kristian_kolb
Ultra Champion

with strptime;

...| eval my_new_time = strptime(mytime, "%Y%m%d")

/k

0 Karma

Damien_Dallimor
Ultra Champion
... | eval mytime=strftime(_time, "%Y%m%d") | table mytime
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>