Date Time Format in Where Clause. I can't get the date formula to work!!

[Fig1]

Where Clause:

DATETIME >=TO_DATE('2019-12-01 00:00:00', 'YYYY-MM-DD hh:mm:ss')

(DATETIME field: numeric, timestamp - 2009-01-30 10:00:00.000000)

[tresesco]

to_date() is not a qlik function. Are you using this where clause under sql select?

[Fig1]

Yes SQL select

The database i am connecting to is oracle

[tresesco · Accepted solution]

Oracle date-timestamp formats are unlike qlik. Try like:

TO_DATE('2019-12-01 00:00:00', 'YYYY-MM-DD HH:MI:SS')