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');