Beginners turn, a comparison date problem-CodePudding

Home > database > Beginners turn, a comparison date problem

Beginners turn, a comparison date problem

Time：09-20

The case when weeknum<'2019-12-15' then concat (' W ', weekofyear (date_add (weeknum, 15)))
The when weeknum='2019-12-15' then 'W53'
The when weeknum> '2019-12-15' then concat (' W ', weekofyear (date_add (weeknum, 8)))

Can the date which is excuse me?

Page link：https//www.codepudding.com/database/15156.html

Prev:Passing the man can help me to look at the code have what problem

Next:SQL import data in this problem we need to do

Tags：

The base class

Links：
CodePudding