how to get a date of this weekend in mysql code example Example: mysql date of the week DAYOFWEEK(date)