with temp(st_dt) as 
(
values(date('2009-04-06') )
)
,
dt_tm_rec(dt,tm) as 
(
select st_dt,time('00.00') from temp
union all 
select date(timestamp(dt,tm)+1 hour),time(timestamp(dt,tm)+1 hour) from dt_tm_rec, temp where dt<(st_dt+1 year-1 day)
)
select  dt,tm from dt_tm_rec