I have a column with a datatype number but I want to convert the column into date. I tried using CAST function but it gives error

> 
> ORA-00932: inconsistent datatypes: expected DATE got NUMBER.
> 
> 
> 

For example, 20221203 to 2022-12-03.

Any suggestions?

col\_date is the column name

```
select cast(col_date as date)
from school

```