Kamlesh Kamal
New User
Joined: 16 May 2008
Posts: 3
Location: Kolkata,India
|
|
|
|
Hi
My requirement is to round off a float value through SQL query .Viz (12.51 divided by 21.95 = 0.56993). The result should be 0.570, not 0.569. As of now the query that i have is
EXEC SQL
UPDATE PRPL
SET PRPL_POUT_RT =
(CASE
WHEN (SCHA_AMT + SCHB_AMT+
NPROP_AMT) <> 0 AND
(SCHA_GDC_AMT + SCHB_GDC_AMT +
NPROP_GDC_AMT) <> 0
THEN
DECIMAL(
FLOAT (
(SCHA_AMT + PRPL_SCHB_AMT+
NPROP_AMT)/
FLOAT(
(SCHA_GDC_AMT + SCHB_GDC_AMT +
NPROP_GDC_AMT))),12,3)
ELSE 0.0
END)
What modification is needed for this work as required. |
|
