Six Stars

Filter on Date column with Date datatype using tmap

 Hi,

 

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 ?

1 REPLY
Forteen Stars TRF
Forteen Stars

Re: Filter on Date column with Date datatype using tmap

Hi,

Check for TalendDate routines here.

addDate and compareDate is what you need to use to solve your case.


TRF