Código SQL [-]SELECT * FROM TABLA WHERE CAST(FECHA AS DATE) BETWEEN '01.01.2017' AND '10.01.2017' AND CAST(FECHA AS TIME) BETWEEN '08:00:00' AND '12:00:00'
SELECT * FROM TABLA WHERE CAST(FECHA AS DATE) BETWEEN '01.01.2017' AND '10.01.2017' AND CAST(FECHA AS TIME) BETWEEN '08:00:00' AND '12:00:00'