SQL - Get difference between two dates (by year/month/day)
Jump to navigation
Jump to search
select
trunc(months_between(fac_dte_final_mat+1,fac_dte_effective) /12) ||' Years '||
trunc(months_Between(fac_dte_final_mat+1,fac_dte_effective)) ||' Months '||
trunc(fac_dte_final_mat-fac_dte_effective+1) || ' Days '
"Duration Pricing (fac)"
from
vls_facility;