Viewing 3 posts - 1 through 3 (of 3 total)
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...
February 27, 2020 at 6:16 pm
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...
February 27, 2020 at 4:13 pm
I would use SYSDATETIME() instead of GETDATE() in examples as a better choice these days
February 27, 2020 at 9:04 am
Viewing 3 posts - 1 through 3 (of 3 total)