# Documentation of CONVERT\_TO\_FLOAT
**URL:** https://community.dremio.com/t/documentation-of-convert-to-float/5770
**Category:** Uncategorized
**Created:** [June 22, 2020, 7:34am UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770 "2020-06-22T07:34:00Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@unni](https://community.dremio.com/u/unni)
#### Post date: [June 22, 2020, 7:34am UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770/1 "2020-06-22T07:34:00Z")
Hi,
Is there any documentation for type conversions.
The Dremio UI is using CONVERT\_TO\_FLOAT(sales, 1, 1, 0) when data type is changed. But cannot find the details of the parameters required in the documentation.
[https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html](https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html)
---
### Author:  [@Rakesh\_Malugu](https://community.dremio.com/u/Rakesh_Malugu)
#### Post date: [June 25, 2020, 3:36am UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770/2 "2020-06-25T03:36:54Z")
Hello @unni
When we use some the type conversion in the Dremio UI, in particular with conversion from text to numeric values, these functions are used. We generally do not document them because they are non-standard functions and we prefer that you use those with the stable function signature.
That being said, we realize that customers have used these in their VDS, so we will not be changing them any time in the near future.
Thanks,
@Rakesh_Malugu
---
### Author:  [@unni](https://community.dremio.com/u/unni)
#### Post date: [June 25, 2020, 3:54am UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770/3 "2020-06-25T03:54:07Z")
@Rakesh_Malugu Thank you
---
### Author:  [@donaldtse118](https://community.dremio.com/u/donaldtse118)
#### Post date: [June 15, 2023, 11:30am UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770/4 "2023-06-15T11:30:21Z")
Hi @Rakesh_Malugu,
Might I know what standard function to use to convert a string column to integer data type with handling that null values or some value is not an integer? thanks.
Donald
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [June 15, 2023, 1:33pm UTC](https://community.dremio.com/t/documentation-of-convert-to-float/5770/5 "2023-06-15T13:33:46Z")
@donaldtse118 What version of Dremio are you using? Are you getting an error? Can you please share the profile?
Reason I am asking is if you are hitting a file schema and table schema data types are different