The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.

Datetime format in logfiles

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

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    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
  • d4emuellerd4emueller Member Posts: 4 Contributor I
    fine - works as discribed.
    thank you!
    Ines
Sign In or Register to comment.