Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Mark Leith (mleithmysql.com)
Date: Fri Jul 13 2007 - 04:59:03 CDT
> 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()..
Mark Leith, Senior Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql