Datetime format in logfiles
d4emueller
New Altair Community Member
Hello,
I used the jerzyblog rezipe to import with Read Server Log Operator Logfiles. All is fine but the generated time-field values. These generated datetime-values are Integers like 23666548 - generate attribute / date_parse() will transform this in a date like 1.10.1971
Anyone knows, what to do. I want generate date from datetime ...
Date Example from logfile:
[31/Dec/2014:03:28:22 +0100]
field-definition in logfile-Config
<field class="org.polliwog.fields.DateTimeField" openQuote="[" closeQuote="]">
<param id="locale" value="en/US"/>
<param id="format" value="dd/MMM/yyyy:HH:mm:ss Z"/>
</field>
seems to me appropriate ...
I used the jerzyblog rezipe to import with Read Server Log Operator Logfiles. All is fine but the generated time-field values. These generated datetime-values are Integers like 23666548 - generate attribute / date_parse() will transform this in a date like 1.10.1971
Anyone knows, what to do. I want generate date from datetime ...
Date Example from logfile:
[31/Dec/2014:03:28:22 +0100]
field-definition in logfile-Config
<field class="org.polliwog.fields.DateTimeField" openQuote="[" closeQuote="]">
<param id="locale" value="en/US"/>
<param id="format" value="dd/MMM/yyyy:HH:mm:ss Z"/>
</field>
seems to me appropriate ...
Tagged:
0
Answers
-
Hi,
I just had a look at the code. It does not produce datetime attributes, but time attributes. As such it takes the milliseconds since 1970 and divides them by 60000. In other words, take the numbers you are getting, multiply them by 60000 and then parse it as a date. Quick test with the number you provided resulted in
Regards,
23666548*60000=1419992880000
parseDate(1419992880000)= Wed Dec 31 2014 03:28:00 GMT+0100
Marco0 -
fine - works as discribed.
thank you!
Ines0
