Scott Scott - 2 months ago 13
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
SELECT LEAST(date_1, date_2) FROM DUAL;

Oracle LEAST

Comments