SQL Select Count Column Between two Times

for mysql may be can use :

SELECT TIMESTAMPDIFF(MINUTE,'2013-01-01 09:00:00.000','2013-01-01 09:05.000') ; // return result as minutes

read here : http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

The SQL looks fine although it returns 6. Did you want that or did you want 5? You could always just start your SELECT criteria from 09:01:00.000 if that's what you want.

SQLfiddle here: http://sqlfiddle.com/#!2/d3f13/2

I am not getting exactly what you want. But if want to extract minute from your date then use following query.

SELECT EXTRACT(MINUTE FROM Open_Time) FROM test_table;

SELECT EXTRACT(MINUTE FROM Open_Time)-10 FROM test_table;

Above query will give only difference in minute. so check you DAY,HOUR,MINUTE,SECONDS based on your criteria

In sql server you can use DATEDIFF function,wich accept folowing parameters: DATEDIFF(datepart,startdate,end date) and returns count(int) between specified date boundaries for selected datepart,so you could use something like this:

select DATEDIFF(mi,MIN(opentime),MAX(opentime)) AS 'minutes'
from test_table
where open_time between '2013-01-01 09:00:00.000' and '2013-01-01 09:05.000'

You also cloud count minutes from column "minutes",but it will be very hard to count them with current date(unless,every time when counting you insert current time in the table,or create temp table) !