I am new to talend.
I need get data based on yesterdays date in talend using tmap. like (
SELECT * FROM table WHERE DATE(created_at) = DATE(NOW() - INTERVAL 1 DAY); in mysql.)
I am using date datatype in source content.
How can i achieve this ?
Check for TalendDate routines here.
addDate and compareDate is what you need to use to solve your case.