TRUNCATE(x,d)
Description:
Returns the value of x truncated to d decimal places.
Examples:
But beware:
TRUNCATE(2.26,2) returns 2.25 because non-integer numbers are normally stored as double precision values.
TRUNCATE(2.26,4) returns 2.2599.
See also:
ROUND(), FORMAT()
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.