Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
DB1620106300
Contributor
Contributor

tOracleInput - Datetime Filter Issue

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
Labels (3)
1 Reply
Anonymous
Not applicable

Hi

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