Or query for the appropriate range ...
(in the real world of course hire date is unlikely to have a time component, but I guess this is just an example?)Code:select hiredate from EMP where hiredate between to_date('2006-01-01','YYYY-MM-DD') and to_date('2006-01-01'||' 23:59:59','YYYY-MM-DD HH24:MI:SS')




Reply With Quote