0

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

fork query

edited oct 28

created oct 28 jon.doe37308