problem to load data in script for on deux rolling year
Hello
I want to load datas contained in an ORACLE table database with a loading script on 2 rolling years
I tried this script:
LOAD date (DATETPT) as DATETPT_DTI, // Date of request REFDTI, // Unique number ref request (link to the table ... SQL SELECT * FROM PTAH.PCADTI WHERE PTAH.DATETPT <NOW () AND PTAH.DATETPT> DATE_SUB (NOW (), INTERVAL 2 YEAR);
When I start loading, I have a SQL error that tells me a bracket error on the right
PS: The statement (without the WHERE clause) works