| DATE | Converts a value to DATE. Format: "YYYY-MM-DD" |
| DATETIME | Converts a value to DATETIME. Format: "YYYY-MM-DD HH:MM:SS" |
| TIME | Converts a value to TIME. Format: "HH:MM:SS" |
| DECIMAL[(M[,D])] | Converts a value to DECIMAL. It has two optional arguments M and D defining the maximum the number of digits and the number of digits after the decimal point. Default, D is 0, Mequals 10. |
| CHAR[(N)] | Converts a value to CHAR. As optional argument, you can pass the maximum length lines. |
| SIGNED | Converts a value to BIGINT. |
| UNSIGNED | Converts a value to unsigned BIGINT. |
| BINARY | Converts a value to BINARY. |
| YEAR | Converts a value to year. |
