Snowflake Vs MS-SQL - Part 81 - First Day Of The Month - DATE_TRUNC
First Day Of The Month Suppose you calculate the first day of the month based on today's date. MS-SQL Server We can achieve it by using built-in functions as below: In Snowflake, we can use a similar approach; however, we can use DATE_TRUNC as below: This can also be used for Year & Week. For more details, refer to the DATE_TRUNC section . Yogesh Shinde LinkedInProfile <<< Back Next >>>