Splunk Search

Time part is discarding

sheshanath
Loves-to-Learn Lots

I have a timestamp variable  EmailSendAt=2020-07-15 05:52:13.186 , 

Whenever I am using
stats value(EmailSendAt) as time..

It shows me only Date part.. Time part is discarding. (I used table also but no change happen)

Labels (1)
0 Karma

to4kawa
Ultra Champion
index=_internal |head 1| fields _raw _time 
| eval _raw="EmailSendAt=2020-07-15 05:52:13.186 , "
| rename COMMENT as "the logic"
| kv

your fields extractions is wrong. try kv

0 Karma

sheshanath
Loves-to-Learn Lots

EmailSendAt is a field and whenever I pull this field with by 

stats values(EmailSendAt) as time .... it shows only date part.

 

For example suppose 

EmailSendAt=2020-07-15 05:52:13.186

then using  stats values(EmailSendAt) as time  only shows me date part. Please help

.

Thanks 

0 Karma

to4kawa
Ultra Champion

try kv before stats

0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...