Show the Number of Months Between Two Dates 
--
-- Show the Number of Days Between Two Dates
--
 
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
 
SELECT ROUND ( (MONTHS_BETWEEN ('01-Jan-2000', '01-Jan-2010'), 0) FROM DUAL
/

Published 1st January 2022

months_betweensysdate
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License