Muhammad Faizan

• Jul 7th, 2015

 

You can use a dateadd() function if you are talking about SQL Server query. In order to get the results from 5 days before the given date.

girisha

• Aug 6th, 2015

 

Code
SELECT * FROM emp WHERE DateDiff(dd,getdate(),hiredate) >5

farhan

• Oct 15th, 2015

 

Code
SELECT * FROM emp WHERE DateDiff(dd,getdate(),hiredate) >5

smangat

• Dec 2nd, 2015

 

Code
SELECT * FROM emp WHERE DateDiff(dd,getdate(),hiredate) >5

Muneeb

• Jan 11th, 2016

 

Code
SELECT * FROM emp WHERE DateDiff(dd,getdate(),hiredate) >5

mukesh3208

 Profile Answers by mukesh3208 

• Jan 29th, 2016

 

Code
SELECT * FROM Employee_Salary WHERE DATEDIFF(dd,Hire_Date,getdate()) < 5