Really easy date question - GETDATE()

[jasonsalas]

I'm running into a problem with a certain T-SQL statement...

InsertDate BETWEEN GETDATE() AND GETDATE()-30

Does GETDATE()-30 mean 30 days ago? Or 30 seconds? Or 30 minutes? Or 30 hours?

Thanks!

 

[iArchitect]

-30 is for 30 days ago

 

[JamesLean]

Also, you need to change that to a valid range:

InsertDate BETWEEN GETDATE() - 30 AND GETDATE()

Your query would never return any records.

--James