Date Time Functions MySQL Tutorial

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