Question - is there built-in function to achieve select CONCAT(week(CURRENT_DATE(), 0), ',', year(CURRENT_DATE())), like select weekOfYearAndYear(CURRENT_DATE()) (i made up this function name)? thanks.
I don’t think there’s a function exactly for that. You can try date_format and just pick out the year and month parts.