Date Time Functions MySQL Tutorial

mysql>
mysql> select GET_FORMAT(DATE,'JIS');
+------------------------+
| GET_FORMAT(DATE,'JIS') |
+------------------------+
| %Y-%m-%d               |
+------------------------+
1 row in set (0.00 sec)
mysql>