The following query returns ' -5' (with three leading pad characters). SELECT CAST(-5 AS INTERVAL YEAR(4));