Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
WHERE
ORDER_DATE>={ts '2020-07-01 00:00:00'} ANDORDER_DATE<={ts '2021-05-31 23:59:59'}ANDORDER_DATE <> ADMIT_DATE // I need this to be : date(order_date) <> date (ADMIT_DATE)
WHAT SYNTAX/FORMAT DO I USE TO PULL THE DATE ONLY FROM THESE TWO FIELDS??