tMap dates operations

[EnriqueLDE]

Hi,

I'm working with two dates (format: yyyy-MM-dd HH:mm:ss) like this way: Date_1: 2019-01-01 08:00:00, Date_2: 2019-01-01 12:00:00

What i'd need is the difference between Date_2 and Date_1 and format the result into "HH:mm:ss"

Date_2 - Date_1 = 04:00:00

I guess you can do this operation using tMap.

Thank you,

Enrique

[Anonymous · Accepted solution]

hello @EnriqueLDE ,

by using this query in sql, you will get your output:-

SELECT TIMEDIFF("2019-01-01 08:00:00", "2019-01-01 12:00:00") 

Output:- '-04:00:00'

Warm Regards,
Manish 

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved