Latest date

Hi Gurus,

What function would I use to retrieve the latest date in a SQL?

Thanks!

select min(sysdate) from what_ever;

11:13:38 SQL> select record_to_date from my_table;

RECORD_TO
---------
29-JUL-02
30-JUL-02
31-JUL-02
01-AUG-02

select min(record_to_date) from my_table
11:15:39 SQL> /

MIN(DISTI
---------
29-JUL-02

select max(record_to_date) from my_table
11:15:49 SQL> /

MAX(DISTI
---------

Cheers!
01-AUG-02