Home » SQL & PL/SQL » SQL & PL/SQL » Performing with FloatNumbers (10g, xe, winxp)
Performing with FloatNumbers [message #311905] Mon, 07 April 2008 06:18 Go to next message
Messages: 22
Registered: November 2007
Junior Member
hi everybody...
i have a table that have 5 columns. 2 of them are keeping coordinate of stations. for example:

coord_x coord_y
41.23451231341 29.23132132144
41.137432432 29.432434324324311
....... .....

it's ok up to now. then i have two variables cx,cy then i compared coord_x,cx and coord_y,cy.

But i want to use only 3 digit right from dot of number.

for example, if cx=41.2341111 then the cx and first element of coord_x (41.23451231341) must be same.
I wanna use only three digits after the dot.

thanx for responses...

[Updated on: Mon, 07 April 2008 06:19]

Report message to a moderator

Re: Performing with FloatNumbers [message #311927 is a reply to message #311905] Mon, 07 April 2008 07:07 Go to previous message
Messages: 2818
Registered: May 2007
Location: Scotland
Senior Member
look at the trunc function
Previous Topic: use of union with case
Next Topic: time function (merged)
Goto Forum:

Current Time: Thu Oct 27 16:16:13 CDT 2016

Total time taken to generate the page: 0.11899 seconds