Display four digit year as tax financial academic year
This SQL works for all years from AD 9 onwards: SELECT ‘2011’ , ‘2011’ || ‘/’ || SUBSTR ( 1 + TO_NUMBER ( ‘2011’ ) , -2 ) formatted FROM DUAL ; Results: ‘201 Formatted —- ——— 2011 2011/12
Read More Display four digit year as tax financial academic year