Assuming you are in oracle, I will do it like this:

SELECT *
FROM TicketItem
WHERE CAST(SUBSTR(TO_CHAR(dt_when, 'YYYY-MM-DD HH24:MI:SS'),12,2) AS INT) BETWEEN 7 AND 8
AND TO_CHAR(dt_when, 'Q')...