Ege Demirel
12/16/2024, 6:19 PMArithmetic operations on data type:12 not
supported
has anybody run into this before?Aaron McCausland
12/16/2024, 8:56 PMEge Demirel
12/16/2024, 9:36 PMTO_NUMBER(TO_DATE(TO_CHAR(TRANSACTION.custbodyddate_confirmed, 'mm/dd/yyyy'), 'mm/dd/yyyy') - TO_DATE(TO_CHAR(TRANSACTION.trandate, 'mm/dd/yyyy'), 'mm/dd/yyyy'))
What's even funnier is, even for some reason the number difference is failing
TO_NUMBER(NVL(TO_CHAR(TRANSACTION.custbodyddate_confirmed, 'J'), 1)) - TO_NUMBER(TO_CHAR(TRANSACTION.trandate, 'J'))
Looks like it should work, but failing with same errorAaron McCausland
12/16/2024, 9:43 PM