| AM/PM according to current locale (Variable    |
|                           | lc_time_names).                                |
+---------------------------+------------------------------------------------+
| %r                        | Time in 12 hour format, followed by AM/PM.     |
|                           | Short for '%I:%i:%S %p'.                       |
+---------------------------+------------------------------------------------+
| %S                        | Seconds with 2 digits.                         |
+---------------------------+------------------------------------------------+
| %s                        | Seconds with 2 digits.                         |
+---------------------------+------------------------------------------------+
| %T                        | Time in 24 hour format. Short for '%H:%i:%S'.  |
+---------------------------+------------------------------------------------+
| %U                        | Week number (00-53), when first day of the     |
|                           | week is Sunday.                                |
+---------------------------+------------------------------------------------+
| %u                        | Week number (00-53), when first day of the     |
|                           | week is Monday.                                |
+---------------------------+------------------------------------------------+
| %V                        | Week number (01-53), when first day of the     |
|                           | week is Sunday. Used with %X.                  |
+---------------------------+------------------------------------------------+
| %v                        | Week number (01-53), when first day of the     |
|                           | week is Monday. Used with %x.                  |
+---------------------------+------------------------------------------------+
| %W                        | Full weekday name in current locale (Variable  |
|                           | lc_time_names).                                |
+---------------------------+------------------------------------------------+
| %w                        | Day of the week. 0 = Sunday, 6 = Saturday.     |
+---------------------------+------------------------------------------------+
| %X                        | Year with 4 digits when first day of the week  |
|                           | is Sunday. Used with %V.                       |
+---------------------------+------------------------------------------------+
| %x                        | Year with 4 digits when first day of the week  |
|                           | is Monday. Used with %v.                       |
+---------------------------+------------------------------------------------+
| %Y                        | Year with 4 digits.                            |
+---------------------------+------------------------------------------------+
| %y                        | Year with 2 digits.                            |
+---------------------------+------------------------------------------------+
| %#                        | For str_to_date(), skip all numbers.           |
+---------------------------+------------------------------------------------+
| %.                        | For str_to_date(), skip all punctation         |
|                           | characters.                                    |
+---------------------------+------------------------------------------------+
| %@                        | For str_to_date(), skip all alpha characters.  |
+---------------------------+------------------------------------------------+
| %%                        | A literal % character.                         |
+---------------------------+------------------------------------------------+

Examples
--------

SELECT STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y');
+---------------------------------------------------------+
| STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y') |
+---------------------------------------------------------+
| 2014-06-02                               [ۈ