Date time

First new here so hope doing correctly

I'm looking to create a report that goes back 7 days and add a time format to the report for the start. I.E

Run today and go back 7 days between the time of 11:30:00

I have got the report to run the day part but how can I add the time to state 11:30 in the following

CAST(vint.gems_incident_vw.incident_end_date_time
+ CAST(vint.wcs_time_zone_range_vw.utc_offset_minute _cnt as interval minute (3) )
AS DATE) >= (DATE - 7)
AND CAST(vint.gems_incident_vw.incident_end_date_time
+ CAST(vint.wcs_time_zone_range_vw.utc_offset_minute _cnt as interval minute (3) )
AS DATE) <= (DATE - 0)
)

Dave