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