OraFAQ Forum: SQL & PL/SQL » Different between TRUNC AND ROUND FUNCTION?

Home » SQL & PL/SQL » SQL & PL/SQL » Different between TRUNC AND ROUND FUNCTION?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different between TRUNC AND ROUND FUNCTION? [message #342847]

Mon, 25 August 2008 05:42

tondapi
Messages: 99
Registered: August 2007
Location: usa

Member

Hi

Can any one explain me,what is different between TRUNC function(With dates)and ROUND function(With date) functions.

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #342851 is a reply to message #342847]

Mon, 25 August 2008 05:55

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Please RTFM at http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #342884 is a reply to message #342847]

Mon, 25 August 2008 07:51

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You might want to change your profile here on Orafaq, especially the "Interests" part.

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #342885 is a reply to message #342884]

Mon, 25 August 2008 07:53

Frank
Messages: 7901
Registered: March 2000

Senior Member

joy_division wrote on Mon, 25 August 2008 14:51

especially the "Interests" part.

ROFL

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #342908 is a reply to message #342884]

Mon, 25 August 2008 08:27

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

LOL

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #342936 is a reply to message #342884]

Mon, 25 August 2008 10:33

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

joy_division wrote on Mon, 25 August 2008 14:51

You might want to change your profile here on Orafaq, especially the "Interests" part.

Michel

Report message to a moderator

Re: Different between TRUNC AND ROUND FUNCTION? [message #343182 is a reply to message #342936]

Tue, 26 August 2008 09:51

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Lets be fair - it didn't say 'Finding'...

Report message to a moderator

Previous Topic:	How to avoid duplicate rows from the result of a query ?
Next Topic:	Reg accessing one user's object from other users with read only option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 07 21:06:48 CDT 2025