SQL server without function said this year
Can use the date> '2020-1-1' and date & lt; '2020-12-31' said

CodePudding user response:

Date between '2020-1-1' and '2020-12-31', you own it to date>='2020-1-1' and date & lt;='2020-12-31' otherwise, on January 1 to December 31 you won't get it

CodePudding user response:

reference 1/f, big watermelon cut a piece of a kilo of reply:

date between '2020-1-1' and '2020-12-31', you own it to date>='2020-1-1' and date & lt;='2020-12-31' otherwise, from January 1 to December 31 you won't get it

Thank you test over sent a little bit