serg-52 (9/23/2014)

---

If rounded interval is needed

SELECT

timeStart =

DATEADD(MINUTE

,-DATEPART(MINUTE,getdate())

,DATEADD(SECOND

,-DATEPART(SECOND,getdate())

, DATEADD(MS,

-DATEPART(ms,getdate())

,getdate())))

,timeEnd =

DATEADD(MINUTE

,-DATEPART(MINUTE,getdate()) + 60

,DATEADD(SECOND

,-DATEPART(SECOND,getdate())

, DATEADD(MS,

-DATEPART(ms,getdate()) - 1

,getdate())));