| <table class="table"> |
| <thead> |
| <tr> |
| <th style="width:25%">Function</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td>bigint(expr)</td> |
| <td>Casts the value `expr` to the target data type `bigint`.</td> |
| </tr> |
| <tr> |
| <td>binary(expr)</td> |
| <td>Casts the value `expr` to the target data type `binary`.</td> |
| </tr> |
| <tr> |
| <td>boolean(expr)</td> |
| <td>Casts the value `expr` to the target data type `boolean`.</td> |
| </tr> |
| <tr> |
| <td>cast(expr AS type)</td> |
| <td>Casts the value `expr` to the target data type `type`.</td> |
| </tr> |
| <tr> |
| <td>date(expr)</td> |
| <td>Casts the value `expr` to the target data type `date`.</td> |
| </tr> |
| <tr> |
| <td>decimal(expr)</td> |
| <td>Casts the value `expr` to the target data type `decimal`.</td> |
| </tr> |
| <tr> |
| <td>double(expr)</td> |
| <td>Casts the value `expr` to the target data type `double`.</td> |
| </tr> |
| <tr> |
| <td>float(expr)</td> |
| <td>Casts the value `expr` to the target data type `float`.</td> |
| </tr> |
| <tr> |
| <td>int(expr)</td> |
| <td>Casts the value `expr` to the target data type `int`.</td> |
| </tr> |
| <tr> |
| <td>smallint(expr)</td> |
| <td>Casts the value `expr` to the target data type `smallint`.</td> |
| </tr> |
| <tr> |
| <td>string(expr)</td> |
| <td>Casts the value `expr` to the target data type `string`.</td> |
| </tr> |
| <tr> |
| <td>timestamp(expr)</td> |
| <td>Casts the value `expr` to the target data type `timestamp`.</td> |
| </tr> |
| <tr> |
| <td>tinyint(expr)</td> |
| <td>Casts the value `expr` to the target data type `tinyint`.</td> |
| </tr> |
| </tbody> |
| </table> |