GET_FORMAT returns the format string used by DATE_FORMAT
mysql>
mysql> select GET_FORMAT(DATE,'USA');
+------------------------+
| GET_FORMAT(DATE,'USA') |
+------------------------+
| %m.%d.%Y |
+------------------------+
1 row in set (0.00 sec)
mysql>