March 19, 2020 at 9:54 pm
@Date1 = '20150630'
DATEADD(m,6, @Date1) < DATEADD(m,-12,GETDATE())
Ignore this, i got the answer after validating.
March 19, 2020 at 10:03 pm
With >7000 points, how can you claim to be "new to SQL Server"?
Please attempt your own explanation... then we can check it for you.
March 19, 2020 at 10:56 pm
DECLARE @Date1 datetime = '20150630'
SELECT DATEADD(m,6, @Date1)
'2015-12-30 00:00:00.000'
SELECT DATEADD(m,-12,GETDATE())
'2019-03-19 22:54:19.727'
'2015-12-30 00:00:00.000' < '2019-03-19 22:54:19.727' = TRUE
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy