how to convert timestamp to date in snowflake

0
votes

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?

1
snowflake-cloud-data-platform

1 Answers

1
votes

First of all, Snowflake can convert timestamp to date implicitly. If you get any errors (because of your format), please check the following docs:

Convert Data Types During a Load:

https://docs.snowflake.com/en/user-guide/data-load-transform.html#convert-data-types-during-a-load

TO_DATE function:

https://docs.snowflake.com/en/sql-reference/functions/to_date.html