topic Re: filter data on time basis in Talend Studio

filter data on time basis

Anonymous — Wed, 09 Oct 2019 13:21:12 GMT

hello everyone,

how can we filter data on time basis ?,

i have a tmysql input source data, i want to filter data on time ranges.

input source:-

Ques:- i want to filter data between 06:00:00 to 18:00:00 time ranges .

please help,

thanks in advanced,

Regards,

Manish

Sujay1 — Wed, 09 Oct 2019 14:23:37 GMT

Hi @vitspltalend if your data is coming from databases like mysql you can filter it in DB itself and bring necessary data right ? Something like

select * from table where dt between '2012-03-11 06:00:00' and '2012-05-11 18:00:00' ;

cause filtering in source(DB) is much more effective than bringing all data to talend and then filter it. Just a food for thought.

Anonymous — Wed, 09 Oct 2019 14:37:47 GMT

hello @Sujay ,

thanks for answer,

It will work fine only for one day data, in my requirements there is multiple days.

TRF — Wed, 09 Oct 2019 17:58:07 GMT

select * from yourTable where DATE_FORMAT(dt, '%H%i') between '0600' and '1800'

TRF — Sat, 12 Oct 2019 14:07:13 GMT

Did it help?
If so, thanks to mark your case as solved.