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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend