calculate Date_Diff between same value in one Column

Gopal_Desai
Gopal_Desai New Altair Community Member
edited November 2024 in Community Q&A

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   

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

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

    Best,
    Martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

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

    Best,
    Martin

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.