Returns the fractional part of a number.
Fraction ( numExpr )
numExpr
Any numeric expression.
The data type of the return value is the same as the data type of numExpr.
The following table shows special cases of the return value:
numExpr |
Return value |
---|---|
A date/time value |
The time portion |
An integer |
0 |
NULL |
NULL |