The integer part and fractional part of the decimal number taken in SQL

1. Floor () function.

Select Floor (3.44), 3.44-floor (3.44)

Show:

3 0.44

For negative and positive numbers this function does not handle the same.

No rounding is done for positive numbers. Rounding for negative numbers.

2.

Select CAST (12.3 as int), 12.3-cast (12.3 as int)

Select CAST ( -12.3 as int), -12.3+cast ( -12.3 as int)

Show:

12 0.3

-12-0.3

3.

Select Left ( -12.7,charindex ('. ',-12.7)-1),
SUBSTRING (CAST ( -12.7 as varchar), CHARINDEX ('. ',-12.7), 8000)

Show:

-12.7