Subtracting x days from given date

USE Rohan

GO

CREATE TABLE DATEFIELD(ID INT,NAME VARCHAR(10),DATEFIELD DATE)

INSERT INTO DATEFIELD VALUES(1,'TERMIN','2015-12-19'),(2,'ABORT','2015-12-29'),(3,'USER','2015-12-24'),(4,'SHUTDOWN','2015-12-27')

Ex 1: Here dateadd subtracts 7 days from the current date.

EX 2 : Date Functions in WHERE Clause



SELECT * FROM DATEFIELD

WHERE DATEFIELD >= DATEADD(DAY,-7,CONVERT(DATE,GETDATE()))  AND DATEFIELD <=CONVERT(DATE,GETDATE())

Here dateadd subtracts 7 days from the current date.