|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Greater function ?
From: Mark Leith (mleith
mysql.com)
Date: Fri Jul 13 2007 - 04:59:03 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
aa2788amoropareja.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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]