Scott Scott - 1 year ago 130
SQL Question

Select the minimum of two dates

I want to do the following:

SELECT min( date_1, date_2)
from dual;

But this will fail terribly because min only takes one parameter. Is there another way?

Answer Source
SELECT LEAST(date_1, date_2) FROM DUAL;

Oracle LEAST

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download