I am trying to understand the purpose/need of the TRUNC(date). I went through the documentation in Oracle and the example :
SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR')
"New Year" FROM DUAL;
I am not able to understand why Oct becomes Jan here. Please help me understand this behavior and any real scenarios where this method is used.