Define if time is between 2 hours

MCANTAL1639145723 — Thu, 28 Jul 2022 14:36:38 GMT

Hi,

I need to know if the time of an existing date format (example 2022-07-28 02:32:00) is between 00:00:00 and 05:15:00.

I don't know how to do in TMAP, someone could help me ?

Re: Define if time is between 2 hours

Anonymous — Fri, 29 Jul 2022 08:02:22 GMT

Only the time part needs to be compared, not the date part？

Re: Define if time is between 2 hours

MCANTAL1639145723 — Fri, 29 Jul 2022 08:10:10 GMT

Yes, only the time part

Re: Define if time is between 2 hours

Anonymous — Fri, 29 Jul 2022 09:26:20 GMT

@M CANTAL , no a function we can use directly to compare the time of a date if it is between a time range, here I create a function in a user routine to do it.

package routines;

import java.util.Calendar;

import java.util.Date;

public class MyRoutine {

public static boolean compareTime(Date param1) {

Calendar calendar = Calendar.getInstance();

calendar.setTime(param1);

int hour = calendar.get(Calendar.HOUR_OF_DAY);

int minute = calendar.get(Calendar.MINUTE);

int second = calendar.get(Calendar.SECOND);

Date startDate=TalendDate.parseDate("HH:mm:ss","00:00:00");

Date endDate=TalendDate.parseDate("HH:mm:ss","05:15:00");

Date inputDate=TalendDate.parseDate("HH:mm:ss",""+hour+":"+minute+":"+second);

if(TalendDate.compareDate(inputDate, startDate)!=-1&&TalendDate.compareDate(inputDate, endDate)!=1){

return true;

}else {

return false;

}

This function requires an input parameter with Date type and it returns a booelan value (true or false);

Then, we can call this function on tMap, here is an example.

Hope it helps you!

Regards

Shong

topic Re: Define if time is between 2 hours in Talend Studio

Define if time is between 2 hours

Re: Define if time is between 2 hours

Re: Define if time is between 2 hours

Re: Define if time is between 2 hours