Snowflake Vs MS-SQL - Part 21 - DayName

 

Extract the DayName 

If you want to extract dayname like Sunday, Monday from the date. 

MS-SQL Server 

You can use inbuilt SQL Functions DATENAME.

In Snowflake, we can achieve this by using similar function DAYNAME.

There is an alternative for the above code as below:

For more details, you can refer to the following LINK or LINK .

Yogesh Shinde

LinkedInProfile

<<< Back Next >>>