Where Clause to Return Records for Last 24 Hours

[jw2000]

I have a datetime field, LastUpdate and I would like to return records with LastUpdate datetime within the last 24 hours. How can I do this?

Pseudocode:
Where LastUpdate is >= 24 hours ago ...

 

[jbenson001]

You can try:

select <columns>
from <table>
where datediff(hh, <col>, getdate()) <= 24