Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. GET_FORMAT(TIME,JIS)
mysql>
mysql> select GET_FORMAT(TIME,'JIS');
+------------------------+
| GET_FORMAT(TIME,'JIS') |
+------------------------+
| %H:%i:%s               |
+------------------------+
1 row in set (0.00 sec)
mysql>