How to convert a column value which is like 20220401 of number datatype to 2022-04-01 in snowflake

I have a column of number data type in snowflake that stores values like 20220401, now I need to convert it into date format. Could someone please help

>Solution :

select to_date('02/14/2014', 'MM/DD/YYYY');

create table number_to_date(numbers integer);
insert into number_to_date values (20220401);
select to_date(to_char(numbers),'YYYYMMDD') from number_to_date;

More details: https://docs.snowflake.com/en/sql-reference/functions/to_date.html#examples