trunc function Oracle

1, "trunc (for dates)" trunc () function processing date
Select Trunc (sysdate, ' yy ') from dual;--returns the first day of the year
Select Trunc (sysdate, ' mm ') from dual;--returns the first day of the month
Select Trunc (sysdate, ' DD ') from dual;--returns the current date
2, "TRUNC (for Number)" TRUNC () function handles numeric numbers
Select Trunc (123.567,2) from dual;--123.56, which truncates the digits to the right of the decimal point after the specified number of bits;
Select Trunc (123.567,-2) from dual;--100, the second parameter can be negative, indicating that the decimal point to the left of the specified number of bits after the section, that is, 0;
Select Trunc (123.567) from dual;--123, which by default truncates the part after the decimal point;

trunc function Oracle