After upgrading Active Directory Add-on to pull ldap data, the date fields are coming in a strange format which I cannot figure out how to convert.
The format is %Y%m%d%H%M%S.0Z
For example: 20140402220534.0Z
I assume the .0Z
part is a timezone reference.
Anyhow, I'm trying to convert/display it in a human readable way, but cannot figure it out.
Any ideas?
Hi darlas,
probably there is a better way to do this, but if you take your date string and strptime
first and strftime
after you get something like this 2014-04-02 22:05:34
. Here is the search to get there (the first line is only to create the date string):
| gentimes start=-1 | eval myTime="20140402220534"
| eval HumanTime=strptime(myTime, "%Y%m%d%H%M%S")
| eval HumanTime2=strftime(HumanTime, "%Y-%m-%d %H:%M:%S")
| table myTime HumanTime HumanTime2
BTW the .0Z
means UTC.
Hope this helps ...
cheers, MuS
Hi darlas,
probably there is a better way to do this, but if you take your date string and strptime
first and strftime
after you get something like this 2014-04-02 22:05:34
. Here is the search to get there (the first line is only to create the date string):
| gentimes start=-1 | eval myTime="20140402220534"
| eval HumanTime=strptime(myTime, "%Y%m%d%H%M%S")
| eval HumanTime2=strftime(HumanTime, "%Y-%m-%d %H:%M:%S")
| table myTime HumanTime HumanTime2
BTW the .0Z
means UTC.
Hope this helps ...
cheers, MuS
You are my HERO !