tOracleInput - Datetime Filter Issue

DB1620106300 — Sat, 16 Nov 2024 00:11:33 GMT

I'm trying to extract data from our source database using the tOracleInput component and a simple select statement with the filter below:

WHERE UPDATE_DATE >= '2011-10-07 00:00:00'

AND UPDATE_DATE <= '2011-10-07 23:59:59'

However, it returns incorrect number of rows. Upon further investigation, rows with "2011-10-07 00:00:00"

as update_date cannot be fetched. I also tried changing the filter to

2011-10-06 (previous day)

and I was able to fetch those missing records with 2011-10-07 00:00:00 as update_date. My job is a spark job and I'm using

Talend Data Fabric 7.3.1

Re: tOracleInput - Datetime Filter Issue

Anonymous — Sat, 08 May 2021 02:12:19 GMT

What's the date type of this column in DB? Can you try to change the query as below:

WHERE UPDATE_DATE >= '07-OCT-2011'

AND UPDATE_DATE < '08-OCT-2011'

Regards

Shong