Selecting records, filter by current time and current time minus 5 min

[mitchelt]

Hi,

What I am trying to do in (ASP MSSQL) is to query records by the time submitted as compared to the current time and the current time minus 5 minutes.

The time for the records is captured in this format: HHMMSS into a field called TIMESUBMIT

So if the current time is 7:00:00AM the query would be:

Select records where TIMESUMBIT is => than 065500 and TIMESUBMIT <= 070000

I just can't figure out the correct syntax...can some help?

Thanks,

Mitch

 

[DotNetGnat]

try something like this:

SELECT records FROM mytable 
WHERE 
DATEDIFF(n, getdate(), TIMESUMBIT)
BETWEEN 0 AND 5

you may also look into some CONVERT() functions if this doesnt work

-DNG