Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

floor Function (XQuery)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the largest number with no fraction part that is not greater than the value of its argument. If the argument is an empty sequence, it returns the empty sequence.

fn:floor ($arg as numeric?) as numeric?


Number to which the function is applied.

If the type of $arg is one of the three numeric base types, xs:float, xs:double, or xs:decimal, the return type is same as the $arg type. If the type of $arg is a type that is derived from one of the numeric types, the return type is the base numeric type.

If input to the fn:floor, fn:ceiling, or fn:round functions is xdt:untypedAtomic, untyped data, it is implicitly cast to xs:double. Any other type generates a static error.

This topic provides XQuery examples against XML instances that are stored in various xml type columns in the AdventureWorks sample database.

You can use the working sample in the ceiling function (XQuery) for the floor() XQuery function. All you have to do is replace the ceiling() function in the query with the floor() function.

These are the limitations:

  • The floor() function maps all integer values to xs:decimal.

Community Additions

© 2015 Microsoft