Getting Data In

How do I change a CSV timestamp?

miguel1423
Explorer

Hello,

I add an CSV data into my splunk without any timestamp and SPLUNK add automatiquely an timestamp with the format "3/16/22 4:33:55.000 PM" I would like change the date on the format "3/16/22" how can I do that ? 

 

Regards,

 

 

Labels (2)
0 Karma

VatsalJagani
Champion

Can you please provide sample data or screenshot of which timestamp you are talking about?

And also how you have added the CSV in Splunk.

0 Karma

vinod743374
Communicator

You Can try Like this,

| eval timeformat=strftime(_time,"%m/%d/%y")

vinod743374_0-1648704080855.png

 

0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...