Talend data refresh

[Jazz_shomp]

Hello All,

I have a scenario where I need to refresh data for last 13 months.

So in the beginning of the job I am calculating date which I will use for this

In tDBInput, I am writing--> "SELECT max(lastupdatedate-interval '13 month') from tbl_name"

I am getting error as "Interval values with month or year parts are not supported".

Can you please tell me what can be the solution for this.

This is urgent, please let me know asap.

Thanks,

[Anonymous]

This is an error from the database. I'd try out your query directly with the DB before using it in a tDBInput component.