how to convert timestamp to date in snowflake

Question

I have to load csv file to snowflake using copy command. These is a timestamp column in csv file, which I need to convert to date and load to snowflake any idea on the command?

Answer 1

one of the easy way to convert timestamp into date in snowflake is If you have created_date = 2023-10-18 08:36:59.098 you want 2023-10-18

cast(CREATED_DT AS Date) it will returns you only date. I hope it will help