Snowflake Vs MS-SQL - Part 95 - Date and Time - INTERVAL

Date and Time - INTERVAL

Often, you need to add a duration/interval to an existing date.

MS-SQL Server

We can achieve it as follows:

In Snowflake,  we can use a similar approach as above; however, we can make use of the new data type INTERVAL as follows:

For more details, refer to the INTERVAL section.

Yogesh Shinde

LinkedInProfile

<<< Back Next >>>

Snowflake Vs MS-SQL - Series