Here you go...

Not the most effecient solution, but it will do

set dateformat ymd

declare @start datetime

declare @increment float

declare @end datetime

set @start=(select cast('2000/01/01' as datetime))

set @end =(select cast('2031/01/01' as datetime))

if exists(select * from sysobjects where name ='Time')

drop table [Time]

Create table [Time]([Date] datetime not null)

while @start <= @end

begin

insert into [Time]

select @start

set @start=@start +(cast(1 as float)/24/4)

end

select * from [time]