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