# CONVERT\_TO BOOLEAN type

**URL:** <https://community.dremio.com/t/convert-to-boolean-type/1782>\
**Category:** Uncategorized\
**Created:** [September 6, 2018, 5:59pm UTC](https://community.dremio.com/t/convert-to-boolean-type/1782 "2018-09-06T17:59:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dealercrm](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dealercrm/32/627_2.png) [@dealercrm](https://community.dremio.com/u/dealercrm)\
**Post date:** [September 6, 2018, 5:59pm UTC](https://community.dremio.com/t/convert-to-boolean-type/1782/1 "2018-09-06T17:59:55Z")

</div>

CONVERT\_TO(OptIn, ‘BOOLEAN’) AS OptIn  
 ![37%20PM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/0e427467a446b5a2eee9147eea801f84ba6ae600.png)

 ![07%20PM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/efd730a470cf3a0af30956e5ab237ba6e970cb07.png)

This does not work.

CONVERT\_TO does not support conversion to type ‘BOOLEAN’.  
[https://docs.dremio.com/sql-reference/data-types.html?h=boolean](https://docs.dremio.com/sql-reference/data-types.html?h=boolean)  
[https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html?h=conversion](https://docs.dremio.com/sql-reference/sql-functions/type-conversion.html?h=conversion)