Getting Data In
Highlighted

How do I convert serial date time?

New Member

How do I convert serial date time (1900 Date System)? For example, I would like to convert
41215.10417 to 11/2/12 2:30 AM

Tags (1)
0 Karma
Highlighted

Re: How do I convert serial date time?

Super Champion

Where are you trying to do the conversion? In a search, or at index time?

0 Karma
Highlighted

Re: How do I convert serial date time?

New Member

I would like to do it at index time but doing it at search would be acceptable.

0 Karma
Highlighted

Re: How do I convert serial date time?

Ultra Champion

Converting to unix time worked for me;

... | eval AAA = (your_time_field - 25569) * 86400 | convert ctime(AAA)

where 25569 is the actual number of days between Jan 1 1900, and Jan 1 1970 (according to some online calendar tool - din't count them myself).

Subtract, multiply, convert, ACTION.

/K

View solution in original post

Highlighted

Re: How do I convert serial date time?

New Member

Works for me.

0 Karma