This will give the greatest date.
Syntax: greatest (date1, date2,
date3 … daten)
to_date(To_char(‘11-jan-2011’,’DD-MON-YY’),
'dd-mon-yy')
Ex:
SQL> select
greatest(to_date('11-jan-90','dd-mon-yy'),to_date('11-mar-90','dd-
mon-yy'),to_date('11-apr-90','dd-mon-yy')) from dual;
GREATEST(
-------------
11-APR-90
