We want to find the crimes committed by an individual within last 10 years.
Is there a more elegant way to do this than below method (in 11g R2)?
SELECT *
FROM txn_table
WHERE date_committed > (SYSDATE - (10*365));
PS: Should we use TRUNC on both dates above???