Get Total_Time from start_DateTime and End_DateTime

[Sbxr80]

Input: data type is Date

2023-12-09T07:43:03.792Z | 2023-12-09T13:51:02.552Z

 

Output:

hh:mm:ss format

[Anonymous]

Hi

I'm afraid there is no direct function to get the result you want, if you have some Java knowledge, you can have a try to hard code on tJavaRow component, use the built-in function TalendDate.getPartOfDate() to get each part of time, then do the subtraction for each part of time and build the output string.

Regards

Shong