topic tMap dates operations in Talend Studio

tMap dates operations

EnriqueLDE — Sat, 16 Nov 2024 04:23:28 GMT

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

Re: tMap dates operations

Anonymous — Mon, 14 Oct 2019 14:38:47 GMT

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