SQL query for today’s date minus year, month, day or minute
To add or subtract some date/time you can use MS SQL function:
DATEADD(datepart, number, date)
Let’s say you need to add five months to current date, use this:
SELECT * FROM YourTable WHERE YourDate < DATEADD(month, 5, GETDATE())
I used function GETDATE() for getting current DateTime.
If you need to subtract some time, just add minus to second param:
SELECT * FROM YourTable WHERE YourDate < DATEADD(month, -5, GETDATE())
List of available arguments for datepart param:
Share your thoughts
You must be logged in to post a comment.