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.

--
David Griffith
dgriffi@cs.csbuak.edu <-- Switch the 'b' and 'u'

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

On 17 Apr, 00:38, dgri...@cs.csbuak.edu (Dave Griffith) wrote:
> 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.
>
> --
> David Griffith
> dgri...@cs.csbuak.edu <-- Switch the 'b' and 'u'

See http://dev.mysql.com/doc/refman/5.0/...atetime_format