Re: Round-off of a float column
- From: "Rob Verschoor" <rob@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 17 Jul 2006 12:19:56 +0200
Use the round() function: this lets you specify how many significant digits
to round to.
HTH,
Rob V.
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
"mullin" <mullin.yu@xxxxxxxxx> wrote in message
news:1152864919.446918.210360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If i want to round off column amount with datatype float of a table,
table1, how can i round it off?
e.g.
amount: 67032 => 67032
amount: 67032.1234 => 67032.1234
amount: 67032.123422 => 67032.123422
amount: 67032.1234228 => 67032.123423
amount: 67032.1234224 => 67032.123422
amount: 67032.123422812 => 67032.123423
amount: 67032.123422489 => 67032.123422
.
- Follow-Ups:
- Re: Round-off of a float column
- From: Rob Verschoor
- Re: Round-off of a float column
- References:
- Round-off of a float column
- From: mullin
- Round-off of a float column
- Prev by Date: object created in a database using reserved word, 'table'
- Next by Date: Re: Round-off of a float column
- Previous by thread: Re: Round-off of a float column
- Next by thread: Re: Round-off of a float column
- Index(es):
Relevant Pages
|
|
