Home » SQL & PL/SQL » SQL & PL/SQL » Different between TRUNC AND ROUND FUNCTION?
Different between TRUNC AND ROUND FUNCTION? [message #342847] Mon, 25 August 2008 05:42 Go to next message
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.
Re: Different between TRUNC AND ROUND FUNCTION? [message #342851 is a reply to message #342847] Mon, 25 August 2008 05:55 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Please RTFM at http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
Re: Different between TRUNC AND ROUND FUNCTION? [message #342884 is a reply to message #342847] Mon, 25 August 2008 07:51 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You might want to change your profile here on Orafaq, especially the "Interests" part.
Re: Different between TRUNC AND ROUND FUNCTION? [message #342885 is a reply to message #342884] Mon, 25 August 2008 07:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
joy_division wrote on Mon, 25 August 2008 14:51
especially the "Interests" part.

ROFL
Re: Different between TRUNC AND ROUND FUNCTION? [message #342908 is a reply to message #342884] Mon, 25 August 2008 08:27 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
LOL
Re: Different between TRUNC AND ROUND FUNCTION? [message #342936 is a reply to message #342884] Mon, 25 August 2008 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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.

Laughing

Michel

Re: Different between TRUNC AND ROUND FUNCTION? [message #343182 is a reply to message #342936] Tue, 26 August 2008 09:51 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Lets be fair - it didn't say 'Finding'...
Previous Topic: How to avoid duplicate rows from the result of a query ?
Next Topic: Ternary Operator in PL/SQL
Goto Forum:
  


Current Time: Tue Dec 06 11:56:30 CST 2016

Total time taken to generate the page: 0.08391 seconds