Tech Diary
August 18, 2014
Oracle Trunc function
Run on 8/18/2014
select trunc(sysdate, 'YYYY') from dual -> 01-JAN-14
select trunc(sysdate, 'MM') from dual -> 01-AUG-14
select trunc(sysdate, 'DD') from dual -> 18-AUG-14
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment