difference between max(datecolumn) and max(to_date(datecolumn),'dd-mm-rrrr')

[TomazZ]

Originally posted by PSoni
PLEASE READ IT AS
select max(to_date(datecolumn,'dd-mm-rrrr)) from atable ;

Still missing a quote here

I believe datecolumn is a character column.