This has two syntax errors - so I don't think this is what gave the output posted.
PLEASE READ IT AS
select max(to_date(datecolumn,'dd-mm-rrrr)) from atable ;


Are you 100% sure? The results suggest that it is a character column - 31 is the highest value for the first two characters.


YES ITS DATE COLUMN


P.SONI