100

MySQL TRUNCATE Function

The truncate() is a Math function of MySQL. This function is used to get the given number truncated up to given certain decimal places.

Syntax

Parameter:

Number: It is the number to truncate.

decimal_places: It is the number of decimal places truncate to.

Returns

This function returns the number truncated to a certain number of decimal places.

Example 1

Output:

Example 2

Output:

Example 3

Output:

Example 4

Output: