calculate Date_Diff between same value in one Column

Gopal_DesaiGopal_Desai Member Posts: 12 Contributor I

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,


Best Answer

Sign In or Register to comment.