topic Time Format conversion using strptime in Getting Data In

Time Format conversion using strptime

asarolkar — Wed, 15 Aug 2012 21:38:36 GMT

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 ?

Re: Time Format conversion using strptime

Ayn — Wed, 15 Aug 2012 22:01:34 GMT

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")

Re: Time Format conversion using strptime

asarolkar — Wed, 15 Aug 2012 23:27:33 GMT

worked like a charm !