🎉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

calculate Date_Diff between same value in one Column

User: "Gopal_Desai"
Gopal_Desai
New Altair Community Member
Updated by Jocelyn

Hello everyone,

I am working with MySQL Database and Rapidminer. I already connected Rapidminer Software with MySQL Database and i get this kind of Table(as you see in photo). Now i would like to calculate Date Time difference between Eingang(Column) and Ausgang(Column). For example For value 4B6B831A (in Column wert-1), i would like to calculate date time difference between Ausgang and Eingang (Jan 4, 2020 1:54:38 - Jan 4,2020 1:49:29 = 00:05:09) . Same for the value 027A4428, It should be  Jan 4, 2020 1:56:13 - Jan 4, 2020 1:50:13 = 00:06:00. I would like calculate every time whenever new values in table update. If anyone know How can i perform this calculation?

Thank you in advance

Best Regards,

Gopal   

Find more posts tagged with

AI Studio
MySQL
Dates + Times
Sort by:
1 - 1 of 11
    User: "MartinLiebig"
    MartinLiebig
    Altair Employee
    Accepted Answer

    did you check the date_diff function in Generate Attribute? Seems like this is what you want to use.

    Best,
    Martin
Quick Links