select 1 - ( (shelf_exp_date-trunc(sysdate)) / (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) from dual;
|Difference in number of minutes between 2 timestamps||16||39|
|Deny Oracle DBAs from Connecting "/ as sysdba"||5||52|
|passing parameters to sql script oracle||4||27|
|Why don't I see Below columns in my Stored Procedure under TMP_RS?||8||17|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!