I am trying to cast an integer(bp.gross_quantity) to decimal and divide quantity by 42 (from gallon to barrels) and round to nearest hundreds.
Getting syntax error.Code:Select round(cast((bp.gross_quantity as dec(15.3))/ 42), 3) as gross_qty,
Results 1 to 2 of 2
Thread: Using Round and Cast
|
|
|