From my experience it is safe to use something like:

dateColumn >= '20200101' AND dateColumn < '20210101'

for any DATE/DATETIME of 2020 dates instead of dateColumn BETWEEN ...

plus those strings of dates...

• This reply was modified 4 years, 9 months ago by  beervolk.

Hello aveek22.

GETDATE() is pretty old function dealing with DATETIME type.

DATETIME is 8 bytes in storage and min value is 1753-01-01 🙁

At the same time SYSDATETIME() deals with DATETIME2 witch can...

• This reply was modified 4 years, 9 months ago by  beervolk.
• This reply was modified 4 years, 9 months ago by  beervolk.

I would use SYSDATETIME() instead of GETDATE() in examples as a better choice these days