PCMech Forums - View Single Post - ASP

UncaDanno · 12-13-2000, 12:53 PM

Try this....

WHERE datediff("h",now(),whatever_the_date_column_is) between 0 and 4

This will select rows where whatever_the_date_column_is is 0 to 4 hours in the future. You can swap the date fields to select rows where the date is 0 to 4 hours in the past.

12-13-2000, 12:53 PM	#4
UncaDanno Member (9 bit) Join Date: Dec 1999 Location: Midland, NC, USA Posts: 292	Try this.... WHERE datediff("h",now(),whatever_the_date_column_is) between 0 and 4 This will select rows where whatever_the_date_column_is is 0 to 4 hours in the future. You can swap the date fields to select rows where the date is 0 to 4 hours in the past.