How to pull records in the past 30min only?

mlong30 · #1 (**permalink**) 06-23-12, 22:31

Hi,

I need to show the count that occurred during the previous 30min. I've been told the following query doesn't work. Any suggestions?

SELECT COUNT(*) FROM sampledata
WHERE (id = 254 AND sub_id = 731) AND (sampledate >= DATEADD(mi, -30, GETDATE()))

Thanks.

r937 · #2 (**permalink**) 06-23-12, 22:49

unfortunately, i am not familiar with the "doesn't work" error message

you will need to be more specific, because the query looks okay to me

there are several unnecessary parentheses, but they will work fine

mlong30 · #3 (**permalink**) 06-23-12, 23:24

sampledate = '6/23/2012 6:26:38 AM'

the query is counting records, that don't meet the time frame.

r937 · #4 (**permalink**) 06-23-12, 23:26

that would suggest that sampledate is VARCHAR instead of DATETIME

true?

mlong30 · #5 (**permalink**) 06-23-12, 23:49

I just checked, and its a datetime field.

imex · #6 (**permalink**) 06-24-12, 01:12

Hi,

Try something like that:

Code:

SELECT COUNT(*) FROM sampledata
WHERE (id = 254 AND sub_id = 731) AND
      (DATEDIFF(mi, sampledate, GETDATE()) between 0 and 30)

Hope it's useful.

Internet Services

Web Development

Digital Marketing

Consumer Tech