Home » SQL & PL/SQL » SQL & PL/SQL » problem in removing data?
problem in removing data? [message #284589] Fri, 30 November 2007 04:19 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi

In my database i have a data like

sales revenu

1.23
2.345
3.4567
0.023 like this, but user want to see the data as

sales revenue
1
2
3
0 how we can do this one ,any one help me plz
Re: problem in removing data? [message #284590 is a reply to message #284589] Fri, 30 November 2007 04:20 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Look at the trunc function, or the FLOOR function
Re: problem in removing data? [message #284591 is a reply to message #284589] Fri, 30 November 2007 04:23 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

see the link

Thumbs Up
Rajuvan.
Previous Topic: how to place a decimal point into a number at a desired position
Next Topic: work out age using two columns
Goto Forum:
  


Current Time: Sat Dec 10 13:01:02 CST 2016

Total time taken to generate the page: 0.08148 seconds