I am currently trying to create a query so that I can see the number of days between the Master data creation date and current date, with below SQL, however, it doesn't work, would you help advice?
SELECT T0."ItemCode", T0."CreateDate", DAYS_BETWEEN (T0."CreateDate", CURRENT_DATE) "days between" FROM DUMMY FROM OITM