Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
/*select class,count(name) from badges WHERE year(date)=2016 and month(DATE)=01 group by class */ select distinct year(date),datename(month,date) from badges WHERE year(date)=2016 SELECT DATENAME(year, '12:10:30.123') ,DATENAME(month, '12:10:30.123') ,DATENAME(day, '12:10:30.123') ,DATENAME(dayofyear, '12:10:30.123') ,DATENAME(weekday, '12:10:30.123');