RoundToTensOfMinutes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

declare @current_time time
declare @minutes_int int
select @current_time = '2018-10-01 10:38:00:000'

select datepart(minute, @current_time) as current_minute

SET @minutes_int = ((select datepart(minute, @current_time)/10) * 10)


select @minutes_int as minutes_int

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results