Splunk Search
Highlighted

Converting time

Path Finder

Hi

How to convert below into readable format ?

41861.003287037
41855.001458333

I was trying this but did not work

strftime(strptime(Close"%m/%e/%Y %l:%M:%S %p"),"%Y-%m-%d %H:%M:%S")

Regards

0 Karma
Highlighted

Re: Converting time

SplunkTrust
SplunkTrust

What do those numbers represent? They certainly are not time strings in the format shown in your strptime command.

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Highlighted

Re: Converting time

SplunkTrust
SplunkTrust

Try something like this (assuming this is excel date )

strftime((Close-25569)*86400 ,"%Y-%m-%d %H:%M:%S")

View solution in original post

0 Karma
Highlighted

Re: Converting time

Path Finder

Hi

It worked thank you. Could you explain my why we substract 25569 and multiply by 86400

Thank you

0 Karma
Highlighted

Re: Converting time

SplunkTrust
SplunkTrust

The base for excel date time is 1/1/1900 and for epoch is 1/1/1970, the 25569 is the adjustment of dates (for 70 years). Multiplication by 86400 is to convert days into seconds (excel shows in days, epoch in seconds)

0 Karma
Highlighted

Re: Converting time

Path Finder

thank you so much

0 Karma