Talend data refresh

Jazz_shomp — Fri, 15 Nov 2024 23:12:29 GMT

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,

Re: Talend data refresh

Anonymous — Tue, 15 Feb 2022 18:44:18 GMT

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