Separates the integer and fractional parts of a floating-point number in SQL

Select Item_no, Actual_hours,

(ACTUAL_HOURS/8) as days,

--charindex ('. ', cast ((ACTUAL_HOURS/8) as varchar))-1 as Dianindex,

--cast (Left (cast (ACTUAL_HOURS/8) as varchar), CHARINDEX ('. ', cast ((ACTUAL_HOURS/8) as varchar))-1) as int) as Zhengshu,

--convert (Decimal (18,4), (' 0. ') +reverse (CAST (CAST (reverse (substring (ACTUAL_HOURS/8) as varchar, charindex ('. '), cast ((ACTUAL_HOURS/8) as varchar)) + 1, Len (CAST ((ACTUAL_HOURS/8) as varchar)))) (as))) *8 as hours,

--cast (Left (cast (ACTUAL_HOURS/8) as varchar), CHARINDEX ('. ', cast ((ACTUAL_HOURS/8) as varchar))-1) as

Start_date,actual_begin_date

--into #ta

From Work_item

Where actual_complete_date is not null and actual_hours=8--and charindex ('. ', cast ((ACTUAL_HOURS/8) as varchar)) -1<=- 1

Separates the integer and fractional parts of a floating-point number in SQL