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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment