Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamaldeshapryia
Starting Member
3 Posts |
 Posted - 2010-06-10 : 09:04:55
|
| please let me how i can round down a mount in Sql tabelEg : Amount 1751.35 Should round down to 1750.00I need to know Sql query to solve this issue Thank you |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-10 : 09:16:45
|
| What do you want for 1757.35 ?MadhivananFailing to plan is Planning to fail |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-10 : 09:55:12
|
| select round(1751.35, -1) |
|
|
|
kamaldeshapryia
Starting Member
3 Posts |
Posted - 2010-06-14 : 02:04:40
|
quote:
Originally posted by madhivanan
What do you want for 1757.35 ?MadhivananFailing to plan is Planning to fail
|
|
|
|
kamaldeshapryia
Starting Member
3 Posts |
Posted - 2010-06-14 : 02:05:38
|
| it's also should be 1750.00kamal |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-14 : 03:11:55
|
| select floor(1757.35/10)*10MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
sql formula