Tuesday 29 December 2015

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.






No comments:

Post a Comment