Date Time Functions MySQL Tutorial

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