Operations with timestamps

PapadPapad Computer Science StudentMember Posts: 68 Guru
edited June 2019 in Help
Hello,
I want to generate a new binominal column in my dataset. The formula I want to give is : 
when I substract two timestamps and the result is 10 seconds then put 0, else put 1.
Generally, I want my feedback every 10 seconds so if a next timestamp is after a different time , there is a problem which I have to see. So how could I do it? 
Thanks in advance.
Tagged:

Best Answer

  • sgenzersgenzer 12Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    Solution Accepted
    hi @Papad you can do this with Generate Attributes using the date_diff() function. It takes two timestamp attributes and calculates the difference between them in milliseconds. Just divide by 10000 and that should work for you.

    Scott

    varunm1Papad
Sign In or Register to comment.