/ (add_months(trunc(sysdate),60) - trunc(sysdate)) )
from built_items where bar_code = 33502238
select shelf_exp_date, trunc(sysdate), shelf_exp_date-trunc(sysdate)
from built_items where bar_code = 33502238;
select add_months(trunc(sysdate),60) - trunc(sysdate)
I have included a screen print that shows the shelf life. It may be years, days, weeks etc. So I want one function that can take input of shelf life and convert to days and get the percentage shelf life remaining. Help appreciated.