Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Oracle date-timestamp formats are unlike qlik. Try like:
TO_DATE('2019-12-01 00:00:00', 'YYYY-MM-DD HH:MI:SS')
to_date() is not a qlik function. Are you using this where clause under sql select?
Yes SQL select
The database i am connecting to is oracle
Oracle date-timestamp formats are unlike qlik. Try like:
TO_DATE('2019-12-01 00:00:00', 'YYYY-MM-DD HH:MI:SS')