Get the Integer part after Decimal part.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 173
Again we can achieve with the help of Floor method,
DECLARE @Input DECIMAL(10,4);
SET @Input = 12345.6789;
SELECT FLOOR(@Input) AS [IntegerPart]
GO

Output:-
12345

Comments or Responses

Login to post response