with temp(st_dt) as
select st_dt,time('00.00') from temp
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
Visit the new-look IDUG Website , register to gain access to the excellent content.