Re: USAGE OF ROUND AND TRUNC FUNCTIONS

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 14 Feb 2005 14:16:32 +0100
Message-ID: <cuq8bg$rh1$1@news.BelWue.DE>

arijitchatterjee123_at_yahoo.co.in wrote:
> 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
>

Change the date from may to october, then you'll see the difference.

HTH
Holger Received on Mon Feb 14 2005 - 07:16:32 CST