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