tHSQLDbInput: sintax to format date in Where condition

AlessandroCic — Fri, 15 Nov 2024 23:00:07 GMT

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

Re: tHSQLDbInput: sintax to format date in Where condition

AlessandroCic — Thu, 21 Apr 2022 10:37:44 GMT

Up...