Thursday, July 14, 2016

mysql group by week number

To group by week number in my sql, the fuction DATE_FORMAT() can be used.

%U Week (00-53) where Sunday is the first day of week

http://www.w3schools.com/sql/func_date_format.asp

No comments:

Post a Comment