# CHANGE\$1DATA\$1TYPE


Changes the data type of an existing column.

If a column value can’t be converted to the new type, it will be replaced with NULL. This can happen when a string column is converted to an integer column. For example, string "123" will become integer 123, but string "ABC" cannot become a number, so it will be replaced with a NULL value.

**Parameters**
+ `sourceColumn` – The name of an existing column.
+ `columnDataType` – New type of the column. The following data types are supported:
  + **byte: **1-byte signed integer numbers. The range of numbers is from -128 to 127.
  + **short: **2-byte signed integer numbers. The range of numbers is from -32768 to 32767.
  + **int: **4-byte signed integer numbers. The range of numbers is from -2147483648 to 2147483647.
  + **long: **8-byte signed integer numbers. The range of numbers is from -9223372036854775808 to 9223372036854775807.
  + **float: **4-byte single-precision floating point numbers.
  + **double: **8-byte double-precision floating point numbers.
  + **decimal: **Signed decimal numbers with up to 38 digits total and 18 digits after the decimal point.
  + **string: **Character string values.
  + **boolean: **Boolean type has one of two possible values: `true` and `false` or `yes` and `no`.
  + **timestamp: **Values comprising fields year, month, day, hour, minute, and second.
  + **date: **Values comprising fields year, month and day.

**Example**  
  

```
{
    "RecipeAction": {
        "Operation": "CHANGE_DATA_TYPE",
        "Parameters": {
            "sourceColumn": "columnName",
            "columnDataType": "boolean"
        }
    } 
 }
```