[SQL] Creating timestamps in queries?

[Rob S.]

Hi all,

I would like to say,

"select * from blah where stamp >= 7 days ago"

...where the "days ago" is calculated at query time; meaning that its not
hardcoded into the query as a date string.  Is this possible?

TIA! =)

- Rob Slifka