Mega Code Archive

 

Categories / MSSQL Tutorial / Math Functions

 

Returning the decimal portion using FLOOR

4> 5> 6> SELECT 1.22-FLOOR(1.22) 7> GO --------      .22 (1 rows affected) 1>