Trunc Date In Oracle. If you want to consider the different elements separately, you can use something like. In oracle, trunc function, when applied for a datetime value, truncates it to the specified part (to day, by default).
Trunc function (with dates) description. I'd rather run query, and then check actual execution. Syyyy, yyyy, year, syear, yyy, yy, y: