Bug #9054 | date_format with local language output for month name etc. | ||
---|---|---|---|
Submitted: | 8 Mar 2005 19:42 | Modified: | 21 Sep 2006 21:42 |
Reporter: | Emanuele Dolis | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | OS: | ||
Assigned to: | CPU Architecture: | Any |
[8 Mar 2005 19:42]
Emanuele Dolis
[27 May 2006 13:37]
Valeriy Kravchuk
Thank you for a feature request. It looks reasonable. At least, other RDBMSes, like Oracle, provide this feature.
[21 Sep 2006 21:42]
Peter Gulutzan
A patch for date_format is now in the server source code. An example of how it works: mysql> set names utf8; Query OK, 0 rows affected (0.00 sec) mysql> set lc_time_names='ja_JP'; Query OK, 0 rows affected (0.00 sec) mysql> select date_format(s1,'%W') from t; +----------------------+ | date_format(s1,'%W') | +----------------------+ | 日曜日 | +----------------------+ 1 row in set (0.00 sec) See also bug#17512.