Select data for particular time period

Can I retrieve the data between 2 specified dates and falling between 4th hour of Monday and 10th hour of Thursday everyweek.

Note: The 2 dates, the starting weekday,hour and ending weekday, hour can change depending on the input.

Thanks before hand for the help.

Yes you can.

You simply need to pass the condition in the where clause of your SQL query.