> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/data-types.md).

# Data Types

### Available conversions

<table data-full-width="true"><thead><tr><th>Functions</th><th>String</th><th>Integer</th><th>Decimal</th><th>Boolean</th><th>DateTime</th><th>Date</th><th>Time</th><th>Array</th><th>Object</th></tr></thead><tbody><tr><td>To -> <strong>String</strong></td><td>-</td><td>ToString()</td><td>ToString()</td><td>ToString()</td><td>ToString()</td><td>ToString()</td><td>ToString()</td><td>ToString()</td><td>ToString()</td></tr><tr><td>To -> <strong>Integer</strong></td><td>ToInt(format)</td><td>-</td><td>ToInt() = Trunc()</td><td>ToInt()</td><td>ToInt()</td><td>ToInt()</td><td>ToInt()</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>Decimal</strong></td><td>ToDecimal(format)</td><td>ToDecimal()</td><td>-</td><td>ToDecimal()</td><td>ToDecimal()</td><td>ToDecimal()</td><td>ToDecimal()</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>Boolean</strong></td><td>ToBool()</td><td>ToBool()</td><td>ToBool()</td><td>-</td><td>No</td><td>No</td><td>No</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>DateTime</strong></td><td>ToDateTime(format)</td><td>No</td><td>No</td><td>No</td><td>-</td><td>ToDateTime()</td><td>No</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>Date</strong></td><td>ToDate(format)</td><td>No</td><td>No</td><td>No</td><td>ToDate()</td><td>-</td><td>No</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>Time</strong></td><td>ToTime(format)</td><td>No</td><td>No</td><td>No</td><td>ToTime()</td><td>No</td><td>-</td><td>No</td><td>No</td></tr><tr><td>To -> <strong>Array</strong></td><td>ToArray()</td><td>ToArray()</td><td>ToArray()</td><td>ToArray()</td><td>ToArray()</td><td>ToArray()</td><td>ToArray()</td><td>-</td><td>ToArray()</td></tr><tr><td>To -> <strong>Object</strong></td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>ToObject()</td><td>-</td></tr></tbody></table>

### As parameters for functions

if Yes then functions are working with this types as parameters, no Explicit conversion is needed

<table data-full-width="true"><thead><tr><th>Functions</th><th>String</th><th>Integer</th><th>Decimal</th><th>Boolean</th><th>DateTime</th><th>Date</th><th>Time</th><th>Array</th><th>Object</th></tr></thead><tbody><tr><td><a href="/pages/eC7pwvv8N24sKAtFUMbN"><strong>Math functions</strong></a></td><td>-</td><td>Yes</td><td>Yes</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><tr><td><a href="/pages/WhoDERYRbZEXFbxoytjh"><strong>Window functions</strong></a></td><td>-</td><td>Yes</td><td>Yes</td><td>By function</td><td>By function</td><td>By function</td><td>By function</td><td>-</td><td>-</td></tr><tr><td><strong>Aggr -> Math</strong></td><td>-</td><td>Yes</td><td>Yes</td><td>By function</td><td>By function</td><td>By function</td><td>By function</td><td>-</td><td>-</td></tr><tr><td><strong>String</strong></td><td>Yes</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><tr><td><a href="/pages/FPFo8MsEMnu9Q1P2J8PL"><strong>Regex</strong></a></td><td>Yes</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr><tr><td><a href="/pages/gvmDS4RSyf4HEollJKey"><strong>DateTime</strong></a></td><td>-</td><td>-</td><td>-</td><td>-</td><td>Yes</td><td>Yes</td><td>Yes</td><td>-</td><td>-</td></tr></tbody></table>
