Datetime format in logfiles

d4emuellerd4emueller Member Posts: 4 Contributor I
edited November 2018 in Help
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"/>

seems to me appropriate ...


  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering

    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

    parseDate(1419992880000)= Wed Dec 31 2014 03:28:00 GMT+0100
  • Options
    d4emuellerd4emueller Member Posts: 4 Contributor I
    fine - works as discribed.
    thank you!
Sign In or Register to comment.