Dates and Timestamps – the TRUNC function
For me, TRUNC is one of the handiest Date functions available. If you work with time-based data a lot you’ll frequently find a home for it in your queries. For example, find all objects that were modified yesterday: select * from all_objects where last_ddl_time >= trunc(sysdate)-1 and last_ddl_time < trunc(sysdate) TRUNC isn’t limited to just…