KnowledgeBoat Logo

Informatics Practices

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

SQL Queries

1 Like

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.

Answered By

1 Like


Related Questions