Datetime format in logfiles

d4emueller

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 ...

Marco_Boeck

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

23666548*60000=1419992880000
parseDate(1419992880000)= Wed Dec 31 2014 03:28:00 GMT+0100

Regards,
Marco

d4emueller

fine - works as discribed.
thank you!
Ines