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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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