Getting Data In

Timestamp format for 12-HR format

JelianeL
Explorer

9/12/12 2:25:57.000 PM

Hi all,

Above is my timestamp and I'm using "%d/%m/%Y %H:%M:%S %p"

The format that I used return me all 'AM'.

Guide please 🙂

I used '%p' because I came across one documentation states '%p'

  • The locale's equivalent of AM or PM.
Tags (2)
0 Karma
1 Solution

lain179
Communicator

Try using %I instead of %H ... may be that will work.

"%d/%m/%Y %I:%M:%S %p"

View solution in original post

lain179
Communicator

Try using %I instead of %H ... may be that will work.

"%d/%m/%Y %I:%M:%S %p"

JelianeL
Explorer

Hi, thank you for your reply. It works 🙂

0 Karma
Get Updates on the Splunk Community!

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...

Splunk Enterprise Security: Your Command Center for PCI DSS Compliance

Every security professional knows the drill. The PCI DSS audit is approaching, and suddenly everyone's asking ...

Developer Spotlight with Guilhem Marchand

From Splunk Engineer to Founder: The Journey Behind TrackMe    After spending over 12 years working full time ...