Re: USAGE OF ROUND AND TRUNC FUNCTIONS

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 15 Feb 2005 01:12:23 -0800
Message-ID: <ea01504d.0502150112.2759a6f7@posting.google.com>

Dear Sir,
As per your instruction I run the queries and got these outpous.Here truct return the same year but round next. But my question was what is the usage of these two functions. Through this outputs still I am not clear.

SQL> SELECT trunc (TO_DATE ('27-oct-05'),'YEAR')   2 "New Year" FROM DUAL;
/c clsNew Year

---

01-JAN-05 SQL> SELECT round (TO_DATE ('27-oct-05'),'YEAR')   2 "New Year" FROM DUAL;
/c clsNew Year

---

01-JAN-06 Regards
Arijit Chatterjee Received on Tue Feb 15 2005 - 03:12:23 CST