Andrew Fraser DBA

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