I'm running a test table called SUPPLIER. It has a column called "SUPP_DUE_DATE" for when the the supplier needs to get paid for example.
I'm trying to write a query that will find the days past due from that date.
I've started on this so far:
SELECT ROUND ( (MONTHS_BETWEEN (SUPP_DUE_DATE, 'SYSDATE') * 30), 0)
GROUP BY SUPP_DUE_DATE;
Would something like this work?? I think this is pretty clunky..and wont work. Open to suggestions!