Sql datepart

This article is tagged with: Sql datepart and mysql

sql datepart

SELECT DATEPART(yy, '2017/08/25') AS DatePartInt;

datepart day of week

SELECT DATENAME(DW,'2007-10-30');

This article is tagged with: Sql datepart and mysql