mysql - Subtract one week from current week of the year -
i trying 1 week earlier current week of year sql query returning null. here query
select date_sub(yearweek('2014-01-01'),interval 1 week) what wrong query
if want yearweek of week prior date, can this: note: yearweek results in 6-digit number, first 4 digits week year, trailing 2 digits week number.
select yearweek('2014-01-01' - interval 1 week) if need date 1 week before given date, then:
select '2014-01-01' - interval 1 week
Comments
Post a Comment