SELECT *
    FROM table
    WHERE fromDate >= 2019-01-01 AND toDate <=2019-01-10

SELECT *
FROM table
WHERE fromDate >=  TIMESTAMP'2019-01-01 13:00:00' AND toDate <= TIMESTAMP'2019-01-01 16:00:00'