select all records where date is between now and 5 days ago 1

[lminmei]

i have a datestamp field ("datestamp") in my sql table
how would i write a query to return all records that are date stamped between now() and 5 days ago?

 

[dbomrrsm]

select *
from mytable
where datestamp > GETDATE()-5

[blue]DBomrrsm[/blue]

 

[SQLSister]

There is no datestamp field type in SQL Server nor is there a now() function. Are you using Mircosoft SQL Server or some other database?

Questions about posting. See faq183-874

 

[lminmei]

to answer SQLSister's question... "now()" was only an example of the current date/time, and the "datestamp" field is the name of my field...that's all

thanks dbomrrsm for the help!!!!