q42846557, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

SELECT ROUND(1.945,2), 
ROUND((ROUND((7002) / '1') * '1') / 3600,2) AS param_rounded, 
ROUND(
       (7002 / '1')* '1'
      / 3603,5
     )AS param_rounded_5_places, 
ROUND(
       (7002 / '1')* '1'
      / 3603,4
     )AS param_rounded_4_places,      
ROUND(
       (7002 / '1')* '1'
      / 3603,3
     )AS param_rounded_3_places,           
ROUND((ROUND((7002) / 1) * 1) / 3600,2) AS hard_rounded,
ROUND((ROUND((7002) / CAST('1' AS DECIMAL(10,2))) * CAST('1' AS DECIMAL(10,2))) / 3600,2) AS param_rounded_modified;

-- -------------------------------------------------------------------------------------------------------------------

SELECT ROUND(1.945,2), 
ROUND((ROUND((7002) / 1) * 1) / 3600,2) AS param_rounded, 
ROUND(
       (7002 / 1)* 1
      / 3603,5
     )AS param_rounded_5_places, 
ROUND(
       (7002 / 1)* 1
      / 3603,4
     )AS param_rounded_4_places,      
ROUND(
       (7002 / 1)* 1
      / 3603,3
     )AS param_rounded_3_places,           
ROUND((ROUND((7002) / 1) * 1) / 3600,2) AS hard_rounded,
ROUND((ROUND((7002) / CAST(1 AS DECIMAL(10,2))) * CAST(1 AS DECIMAL(10,2))) / 3600,2) AS param_rounded_modified;


absolute service time: 0,38 sec