I have a table with a date timestamp.

I wish to find all records that are between sat 0600hr and 1800hrs
regardless of the date.

I tried (TO_DATE('HH:MI')) however that obviously does not work.

Any help would be appreciated.


Thanks