How to use JDBC Quey Consumer with a Date Offset column?

Userlevel 4

Issue:

Some customers have an issue where incremental mode does not work with their date columns.

Solution:

The Solution is to wrap the ${OFFSET} value in single quotes in the SQL Query field. For example:

select * from t2 where date_changed > '${OFFSET}' ORDER BY date_changed;

You can then put whatever Initial Offset you would like in the initial offset field.

This topic has been closed for comments

Sign up