Re: Query for decimal part
This is a discussion on Re: Query for decimal part within the Informix forums, part of the Database Server Software category; --> Hi Paco: Try with select * from shclog where (amount - amount::int) > 0 HTH ----- Original Message ----- ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:29 PM
| ||||
| ||||
 Re: Query for decimal part Hi Paco: Try with select * from shclog where (amount - amount::int) > 0 HTH ----- Original Message ----- From: "Francisco Roldan" <froldan@5b.com.gt> To: <informix-list@iiug.org> Sent: Thursday, August 21, 2003 11:32 AM Subject: Query for decimal part > Hi Everybody, > I got a table with a column named amount > of type decimal(26,8) . > I need to make a query to select the rows > with no-integers values on this column (amount). > I mean the rows with decimal part on its value. > > Something like this : > > select * from shclog > where get_decimals(amount) <> 0 > > Assuming that the function get_decimals return the > decimal part of the column amount. > > Does exist a function like this ? > > Thanks in advance > sending to informix-list sending to informix-list      |
 |
« Re: Can't restart 9.4 on Linux after the blackout.
|
Re: Can't restart 9.4 on Linux after the blackout. »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:31 PM.
