tHSQLDbInput: sintax to format date in Where condition

[AlessandroCic]

Hi

I'm using tHSQLDbInput and i wold like to filter my records by date.

Each SQL language has its own dialect 😀

I tried the Oracle format:

  Select * From myTable Where myDate > to_date('20180101-000000', 'yyyymmdd-hh24miss')

and also the SQL server format:

  Select * From myTable Where myDate > '2018/01/01'

But I have the error: "invalid datetime format"

What is the correct format to formatting a date in the where condition?

Regards

Alessandro

[AlessandroCic]

Up...