What's wrong with this query .
I am looking for the latest date

select max(to_char(created_date,'dd/mm/yy hh24:mi:ss') from pay_info;

This gives some old data and i know i have latest data

when i query like this it gives me an error

select to_char(max(created_date,'dd/mm/yy hh24:mi:ss') from pay_info;


any idea folks?

thnaks
Ramana