SQL> select to_char(min(to_date(datecolumn,'dd-mm-yyyy')),'dd-mm-yyyy'),to_char(max(to_date(datecolumn,'dd-mm-yyyy')),'dd-mm-yyyy') 2 from atable 3 SQL> / TO_CHAR(MI TO_CHAR(MA ---------- ---------- 16-05-0003 02-07-0003 SQL> select to_char(min(datecolumn),'dd-mm-yyyy'),to_char(max(datecolumn),'dd-mm-yyyy') 2 from test.atable 3 SQL> / TO_CHAR(MI TO_CHAR(MA ---------- ---------- 16-05-2003 31-05-3003 1* select to_char(max(to_date(datecolumn,'dd-mm-yyyy')),'dd-mm-yyyy') from atable SQL> / TO_CHAR(MA ---------- 02-07-0003 SQL>