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

calculate Date_Diff between same value in one Column

Gopal_DesaiGopal_Desai Member Posts: 12 Learner II
in Help

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   

Tagged:

Best Answer

Sign In or Register to comment.