Getting Data In

Time Format conversion using strptime

asarolkar
Builder

I have a date timestamp coming in as a string in this format
2012-08-08 11:29:03.727000000

This is extracted as a field called createDtTimeStamp

I want to simply extract JUST the date part from this field and use the following query:

... | eval createDt = strftime( strptime( createDtTimeStamp, "%b %d %H:%M:%S" ), "%m/%d/%Y %p")

This does not seem to work. Any ideas why ?

1 Solution

Ayn
Legend

Well your format string seems to be off. %b is "Locale’s abbreviated month name." which does not match 2012-08-08. You'll likely want something like

... | eval createDt = strftime(strptime(createDtTimeStamp,"%Y-%m-%d %H:%M:%S"),"%m/%d/%Y %p")

View solution in original post

Ayn
Legend

Well your format string seems to be off. %b is "Locale’s abbreviated month name." which does not match 2012-08-08. You'll likely want something like

... | eval createDt = strftime(strptime(createDtTimeStamp,"%Y-%m-%d %H:%M:%S"),"%m/%d/%Y %p")

asarolkar
Builder

worked like a charm !

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...