equivalent of oracle's nls_date_format
This is a discussion on equivalent of oracle's nls_date_format within the MySQL forums, part of the Database Server Software category; --> 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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 04:09 PM
| ||||
| ||||
 equivalent of oracle's nls_date_format 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'      |
|
04-17-2008, 04:09 PM
| |||
| |||
| Re: equivalent of oracle's nls_date_format 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 |
|
04-17-2008, 04:09 PM
| ||||
| ||||
| Re: equivalent of oracle's nls_date_format 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 |
Linear Mode
