Specific Time Range Query With Hours and Minutes in SQL Server -

Specific Time Range Query With Hours and Minutes in SQL Server -

i'm trying query specific range of time:

i.e. 3/1/2014 - 09/31/2014 between 15:30 - 18:30 each day tues/wed/thurs only

i've seen can info particular range, start end , quite bit more specific. datepart allows 1 time element , didn't see sql server commands straight help me on this, else have thoughts on how form this?

thanks!

select * [order] customerid = [customer].id , businessdate between '2014-03-01' , '2014-09-31' , datepart(hour, firstsendtime) >= 15 , datepart(hour, firstsendtime) <= 18

several ways of range 15:30 - 18:30:

datepart(hour, firstsendtime)*60+datepart(minute, firstsendtime) between 15*60+30 , 18*60+30 left(convert(time, firstsendtime, 114), 5) between '15:30' , '18:30' convert(char(5), firstsendtime, 114) between '15:30' , '18:30'

several ways of range tues/wed/thurs:

datepart(weekday, firstsendtime) between 3 , 5 datename(weekday, firstsendtime) in ('tuesday','wednesday','thursday')

sql-server