Simple SQL Time series generation, 10 minutes each time interval.

CREATE Table #timeseries (times datetime NOT NULL)
Go
DECLARE @firstdate datetime, @lastdate datetime
DECLARE @MI int
Begin
Set @firstdate = ' 8/8/2012 6:00 '
Set @lastdate = ' 8/9/2012 6:00 '
Set @MI =datediff (MI, @firstdate, @lastdate)
--Nested Loops
while (@MI >=0)
Begin
INSERT INTO #timeseries
VALUES (@firstdate)
SET NOCOUNT on
Set @firstdate =dateadd (mi,10, @firstdate)-increments by 10 minutes per start time.
Set @MI =datediff (MI, @firstdate, @lastdate)-when @firstdate is incremented to @lastdate phase, MI is 0, exit loop
SET NOCOUNT Off
End
End
Select Row_number () over (order by times) as ID, CONVERT (varchar), times, as date, times from #timeseries order by Ti MES ASC
drop table #timeseries

Simple SQL Time series generation, 10 minutes each time interval.