The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Operations with timestamps

PapadPapad image 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 image 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

Sign In or Register to comment.