compare date type column

[rei69]

is there anyway i can compare 3 or more date type column?

let's say i have
------------------------------------------------
date1 | date2 | date3
------------------------------------------------
2006-06-01 | 2006-06-15 | 2006-09-19
------------------------------------------------

can i just get the earliest date by command line?
select XXXXX(date1,date2,date3) <--returns '2006-06-01 '
select YYYYY(date1,date2,date3) <--returns '2006-09-19 '

thanks

[rei69]

got the solution

greatest and least are the functions

[guelphdad]

Thanks for coming back to post the solution.