# Conversion

## CAST

```
CAST (dt AS int)
```

Enables conversion of values from one data type to another.

Available in:

<table><thead><tr><th width="275">Processors</th><th>SQL Studio</th></tr></thead><tbody><tr><td>✓</td><td>✓</td></tr></tbody></table>

*Sample code*

```sql
USE `kafka`;
SELECT 
    CAST(price as INT),
    price 
FROM products-events
LIMIT 1;
```

*Output:*

```json
{
  "value": {
    "alias": 2, # new value
    "price": 2.46 # old value
  }
}
```
