Query for getting records older than 10 days from currentdateHai,
I need to get records which are more than or equal to 10 days older from a table.
How to use the date function to retrieve the records.
Please give suggestions
select * from tableName where DateColumn < GETDATE() and DateColumn > getdate()-10
Select * from tablename where col >= dateadd(d,-10,getdate());
select * from tblname where col1 < GETDATE() and DateColcol1umn > getdate()-10
SELECT * from TabName
WHERE DateColumn > dateadd(d,-10,getdate());