Last post Aug 22, 2016 02:59 AM by a2h
Aug 21, 2016 09:26 AM|motorrevo00|LINK
hello, can you help me ..
i want use function group by with substring in mysql
i have field date type number like this 201608XX YYYYMMDD
and i want group by only year and month (201608) without day
please help me =)
Aug 22, 2016 02:59 AM|A2H|LINK
i want group by only year and month (201608) without day
You can make use the substring
function available mysql to extract the year and month.