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:
- year
- quarter
- month
- dayofyear
- day
- week
- weekday
- hour
- minute
- second
- millisecond
- microsecond
- nanosecond