Numbers
Formatting
| functx:ordinal-number-en | Reformats a number as an ordinal number, e.g. 1st, 2nd, 3rd. |
| functx:pad-integer-to-length | Pads an integer to a desired length by adding leading zeros |
| fn:number | Converts a value or a node to a number |
Comparing
| fn:max | The maximum of a sequence of values |
| fn:min | The minimum of a sequence of values |
| functx:is-a-number | Whether a value is numeric |
Calculations
| fn:abs | The absolute value |
| fn:avg | The average of a sequence of values |
| functx:avg-empty-is-zero | The average, counting "empty" values as zero |
| fn:sum | The sum of values in a sequence |
Rounding
| fn:ceiling | Rounds up to the next highest integer |
| fn:floor | Rounds down to the next lowest integer |
| fn:round | Rounds a numeric value |
| fn:round-half-to-even | Rounds a numeric value, rounding even halfs to the nearest even number |
| Need XQuery Help? |
| D A T Y P I C |
| Training | Consulting | Development |
 | Get the book! |
| XQuery by Priscilla Walmsley |