Get the Integer part after Decimal part.

Posted by Vishalneeraj-24503 under Sql Server category on 5/24/2015 | Points: 40 | Views : 946

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

Bookmark It

Latest Code Snipptes