[resolved] How to compare dates in Talend

Anonymous — Mon, 03 Dec 2012 03:39:14 GMT

Hi,
I have two Oracle tables. TableA is the source table and TableB is the datamart table. Both tables have the same structure. What I want to do is to update datamart's TableB with data from TableA.
I have loaded the data from both tables in a HashOutput component and I have made TableB a lookup for Table A.
To update my datamart, I just wanted to look for data where tableA.row_changed_date is greater than tableB.row_changed_date.
I've tried using TalendDate.CompareDate but it seems like it's not working since it's not giving the expected result. Attach is my tmap mapping.. Can someone please check if I'm doing anything wrong? What is the best way to do date comparison in Talend?
I am using TOS5.2.
Thanks,
Josephine

Re: [resolved] How to compare dates in Talend

Anonymous — Mon, 03 Dec 2012 12:53:36 GMT

Hi, Josephine,
Try this TalendDate.diffDate(tableA.row_changed_date, tableB.row_changed_date,"dd") > 0

Re: [resolved] How to compare dates in Talend

Anonymous — Thu, 06 Dec 2012 01:12:25 GMT

Thanks Lino! It worked..

topic Re: [resolved] How to compare dates in Talend in Talend Studio

[resolved] How to compare dates in Talend

Re: [resolved] How to compare dates in Talend

Re: [resolved] How to compare dates in Talend