🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Datetime format in logfiles

User: "d4emueller"
New Altair Community Member
Updated by Jocelyn
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 ...

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "Marco_Boeck"
    New Altair Community Member
    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
    User: "d4emueller"
    New Altair Community Member
    OP
    fine - works as discribed.
    thank you!
    Ines