hi
I want to filter between 'sysdate 22:00:00' and 'sysdate+1day 06:30:00', but when i used timestamp and set time as 22:00:00. it shows hour should be 1~12. and when i use ' 10:00:00 PM' it returns error sql -28 and ORA-01855.
i used the filter as
between cast(concat( _last_of_month (_add_months (sysdate(),-8)),' 10:00:00 P.M.'),timestamp) and cast(concat (_first_of_month (_add_months (sysdate(),-4)),'06:30:00.000'),timestamp)
Any help to achieve this is appreciated