Hi.
How to convert "20180328212007.496740+180" to human readable format?
And if possible without ignores the time zone offset (+180)?
hey@test_qweqwe,
This does not look like an epoch.
Can you try this:
eval time=strftime(strptime("yourtime","%Y%m%d%H%M%S.%6Q+%Ez"),"%Y/%m/%d %H:%M:%S")
Let me know if this helps!!
I have No results found.
InstallDate="20170901111017.000000+180"
LastBootUpTime="20180314062957.183621+120"
| eval LastBootUpTime=strftime(strptime("LastBootUpTime","%Y%m%d%H%M%S.%6Q+%Ez"),"%Y/%m/%d %H:%M:%S")
This worked for me.
|eval LastBoot=strftime(strptime(LastBootUpTime,"%Y%m%d%H%M%S.%N%Z"),"%Y/%m/%d %H:%M:%S")