How to merge the dates into one column?

I have the year, month, day in separate columns and I want to merge them all into one column in snowflake

Solution

select year||'-'||month||'-'||day from table

where year, month and day are column names for corresponding data.