oracle trunc函数截取日期
时间:2022-03-13 23:25
1.select trunc(sysdate) from dual
2.select trunc(sysdate, ‘mm‘) from dual
3.select trunc(sysdate,‘yy‘) from dual
4.select trunc(sysdate,‘dd‘) from dual
5.select trunc(sysdate,‘yyyy‘) from dual
6.select trunc(sysdate,‘d‘) from dual
7.select trunc(sysdate, ‘hh‘) from dual
8.select trunc(sysdate, ‘mi‘) from dual