how to round off 23.01 as 24 in sql server

Hi siva

 

 CONVERT(int,ROUND(AVG(CAST(COLUMN-NAME AS DECIMAL)) ,0))

 

SELECT ROUND(170,0)
SELECT ROUND(96.58,0)

SELECT CAST(170 AS DECIMAL(10,0))
SELECT CAST(96.58 AS DECIMAL(10,0)) 

DECLARE @start time;

DECLARE @end time;

DECLARE @null time;

SET @start = '18:00:00';

SET @end = '20:35:00';

SET @null = '00:00:00';

SELECT DATEADD(SECOND, - DATEDIFF(SECOND, @end, @start), @null)

It's slightly complicated because years, months, weeks, days, hours, minutes and seconds arithmatic is completely different than our decimal arithmatic.

 

So you will need to the following:

 

That means, each part needs to be dealt with separately. Hope you get the point.