How to specify a SQL Function (to_date) in the Data Source Filter value

Matillion ETL
1

Hello,

 

I am trying to use the to_date SQL function in the Data Source Filter for a JDBC connection.

 

Here is what the value looks like:

TO_DATE('2021-05-03 22:30:00', 'YYYY-MM-DD hh24:mi:ss')

 

But this fails.

0694G00000IJKSlQAP_0D54G00008Ao5ozSAB
0694G00000IJKSlQAP_0D54G00008Ao5ozSAB1479×144 6.2 KB

 

Please advise.

 

Thanks.