×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question
rogerbinny
Explorer
Member since: ‎01-20-2015
‎06-05-2020
Community Statistics
Posts 5
Solutions 1
Karma Given 1
Karma Received 0
Member Since ‎01-20-2015
Activity Feed
View All

Re: Extracting date from datetime field

by in Splunk Search
‎02-10-2015 11:17 AM
‎02-10-2015 11:17 AM
Thank you guys for your help! Though my extract_datetime field has %Y-%m-%d %H:%M:%S but when i executed the below search, came to know it is only extracting %Y-%m-%d . sourcetype="something" extract_datetime= * | table extract_datetime Hence updated my search string as below and it works perfectly. Thanks again 🙂 sourcetype="something" extract_datetime= * | WHERE strptime(extract_datetime,"%Y-%m-%d") >= relative_time(now(),"@d") ... View more

Re: Extracting date from datetime field

by in Splunk Search
‎02-09-2015 11:10 AM
‎02-09-2015 11:10 AM
Sorry! Didn't work.. 😞 ... View more

Re: Extracting date from datetime field

by in Splunk Search
‎02-09-2015 11:09 AM
‎02-09-2015 11:09 AM
Sorry, for the format.. Tried the following; but no avail. sourcetype="something" extract_datetime= * | WHERE strptime(extract_datetime,"%Y-%m-%d %H:%M:%S") >= relative_time(now(),"@d") ... View more

Re: Extracting date from datetime field

by in Splunk Search
‎02-08-2015 11:20 AM
‎02-08-2015 11:20 AM
Thanks for your reply. But unfortunately it didn't work.. I tried with the following option - no result(s) returned. sourcetype="something" extract_datetime= * | WHERE strptime(extract_datetime,"%m/%d/%Y") >= relative_time(now(),"@d") -- Replaced -1 & -2 with @d ... View more

Extracting date from datetime field

by in Splunk Search
‎02-08-2015 03:46 AM
‎02-08-2015 03:46 AM
Hi I have field named as "extract_datetime" and it has the following values; 2015-02-08 02:15:24 2015-02-08 02:18:39 2015-02-07 01:38:11 2015-01-28 11:01:00 I want to extract the events which has current date. Lets say today is 8th Feb, i need the first 2 events only. Also there are few values where it has no values (blank). How can i avoid them as well. I tried using now() and strftime () but no avail. Any pointer in this case? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-05-2020 02:04 AM
Karma given to
View All