aa2788@amoropareja.com wrote:
> Hi all,
>
> I'm looking for the mysql equivalent to oracle Greater function. In
> fact, I want to order by the greater of two timestamp fields
>
> order by greater(last_conneciton_date, insert_date)
>
> Anybody knows the way to do it in Mysql ?
>

GREATEST() - and it's opposite LEAST()..

Cheers,

Mark

--
Mark Leith, Senior Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification