blob: 73ea7ef4b0fab9a8e09d2abe7a3640cb4783dfcb [file] [log] [blame]
<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`. `expr` :: `type` alternative casting syntax is also supported.</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>