Friday , June 21 2024

FLOOR Function in SQL Server(TSQL)


The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number as the result. The return data type is the data type of the input parameter.

Below you can see how the FLOOR function behaves at different values.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *