Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. %r
mysql>
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%r');
+------------------------------------------+
| DATE_FORMAT('1997-10-04 22:23:00', '%r') |
+------------------------------------------+
| 10:23:00 PM                              |
+------------------------------------------+
1 row in set (0.00 sec)