Code: Select all
SELECT distinct date_format(l.date, '%V') as weekno, date_format(l.date, '%X%V') as fixed_week_num, date_add(l.date, interval 0 DAY) as ws, date_add(l.date, interval 6 DAY) as we FROM LoadLog l ORDER BY date_format(l.date, '%X %V')Moderator: General Moderators
Code: Select all
SELECT distinct date_format(l.date, '%V') as weekno, date_format(l.date, '%X%V') as fixed_week_num, date_add(l.date, interval 0 DAY) as ws, date_add(l.date, interval 6 DAY) as we FROM LoadLog l ORDER BY date_format(l.date, '%X %V')