Dave Griffith schreef:
> What's the equivalent of doing this:
> ALTER SESSION SET nls_date_format='mon-dd-yyyy hh:miam';
> on MySQL 5.0? Trying to find the answer with Google keeps returning
> MySQL-to-Oracle conversions.
>

this is the closest i can find:
http://dev.mysql.com/doc/refman/5.0/...e-support.html

mysql> SELECT DATE_FORMAT(NOW(),'%b-%d-%Y %l:%i%p');
Apr-17-2008 11:27AM

--
Luuk