Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 8 of 81

MySQL Functions — Question 4

Back to all questions
4
Question

Question 4

What is the difference between round() and truncate() ?

Answer

The difference between the ROUND() and TRUNCATE() functions is that the ROUND() function returns a number rounded off according to the given specifications. On the other hand, the TRUNCATE() function returns a number with some digits truncated. The TRUNCATE() function simply removes the specified digits without rounding them off.