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
Printable View
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
Did you try:
select ...
where to_char(date_col,'HH24:MI')
between '06:00' and '18:00';
;)