select sysdate from dual;--2021-03-15 10:21:35
select trunc(sysdate) from dual;--2021-03-15 00:00:00
select trunc(sysdate, 'mm') from dual;--2021-03-01 00:00:00
select trunc(sysdate,'yy') from dual;--2021-01-01 00:00:00
select trunc(sysdate,'dd') from dual;--2021-03-15 00:00:00
select trunc(sysdate,'yyyy') from dual;--2021-01-01 00:00:00
select trunc(sysdate,'d') from dual;--2021-03-14 00:00:00
select trunc(sysdate, 'hh') from dual;--2021-03-15 10:00:00
select trunc(sysdate, 'mi') from dual;--2021-03-15 10:21:00
select trunc(888.458) from dual; --888
select trunc(888.458,0) from dual; --888
select trunc(888.458,1) from dual; --888.4
select trunc(888.458,-1) from dual; --880
select trunc(888.458,-4) from dual;--0
select trunc(888.458,-3) from dual;--0
select trunc(888.458,3) from dual;--888.458
select trunc(888.458,4) from dual; --888.458
select trunc(888) from dual; --888
select trunc(888,1) from dual; --888
select trunc(888,-1) from dual; --880