Scott Scott - 1 year ago 101
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