how can we filter data on time basis ?,
i have a tmysql input source data, i want to filter data on time ranges.
Ques:- i want to filter data between 06:00:00 to 18:00:00 time ranges .
thanks in advanced,
Solved! Go to Solution.
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.
hello @Sujay ,
thanks for answer,
It will work fine only for one day data, in my requirements there is multiple days.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema