When converting float or numeric data types to int integers, CONVERT will cut the decimal part behind.
See also CAST and TRY_CAST, TRY_CONVERT functions.
CONVERT can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.
For example
Take a look and explore some examples of CONVERT functions in SQL Server.
SELECT CONVERT(int, 14.85); Result: 14 (kết quả cắt phần thập phân phía sau)