USAGE OF ROUND AND TRUNC FUNCTIONS

From: <arijitchatterjee123_at_yahoo.co.in>
Date: 14 Feb 2005 04:49:36 -0800
Message-ID: <1108385376.027518.176970@o13g2000cwo.googlegroups.com>

Dear Faculties,
I have a doubt.
What are the usage of ROUND and TRUNC Functions.

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

New Year

---

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

New Year

---

01-JAN-05 I have the following example.But still I cound not able to understand. Need your help.
Regards
Arijit Chatterjee Received on Mon Feb 14 2005 - 06:49:36 CST