Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Up...