---
title: "floor Function (XQuery) | Microsoft Docs"
ms.custom: ""
ms.date: "03/09/2017"
ms.prod: sql
ms.prod_service: sql
ms.reviewer: ""
ms.technology: xml
ms.topic: "language-reference"
dev_langs: 
  - "XML"
helpviewer_keywords: 
  - "floor function [XQuery]"
  - "fn:floor function"
ms.assetid: 4ace57dd-b66e-4b60-a2b9-a1b0f1a0831d
author: "rothja"
ms.author: "jroth"
---
# Numeric Values Functions - floor
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  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.  
  
## Syntax  
  
```  
  
fn:floor ($arg as numeric?) as numeric?  
```  
  
## Arguments  
 *$arg*  
 Number to which the function is applied.  
  
## Remarks  
 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.  
  
## Examples  
 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)](../xquery/numeric-values-functions-ceiling.md) for the **floor()** XQuery function. All you have to do is replace the **ceiling()** function in the query with the **floor()** function.  
  
## Implementation Limitations  
 These are the limitations:  
  
-   The **floor()** function maps all integer values to xs:decimal.  
  
## See Also  
 [ceiling Function (XQuery)](../xquery/numeric-values-functions-ceiling.md)   
 [round Function (XQuery)](../xquery/numeric-values-functions-round.md)   
 [XQuery Functions against the xml Data Type](../xquery/xquery-functions-against-the-xml-data-type.md)