Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.1Hi
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