-- this is an aux table
 
create table numbers (num int not null primary key);
 -- fill this table with int values from 0 up to (for example) 1000
 
 -- Suppose you have a data
 
create table tmp_data (dt date not null primary key,
data_val int not null,
name varchar( 20 ) not null);

insert into tmp_data (dt, data_val, name)
values ('2003-11-26 10:00:00',  2 , 'sss');
insert into tmp_data (dt, data_val, name)
values ('2003-11-26 11:00:00',  22 , 'jhjkh');
insert into tmp_data (dt, data_val, name)
values ('2003-11-26 14:00:00',  64 , 'fsdf');
insert into tmp_data (dt, data_val, name)
values ('2003-11-26 19:00:00',  2 , 's87');

select t.dt, dt.data_val, 
case when dt.name is null then 'No data' else dt.name end as name
from tmp_data dt right outer join (select date_add( hh, '2003-11-26 09:00:00', num) as dt
from numbers
where num between  0  and  12 ) t on t.dt = dt.dt