/*select class,count(name) from badges WHERE year(date)=2...


Please login or register to vote for this query.

(click on this box to dismiss)


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

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results