SQL can't
create data. It can only manipulate existing data. In the past, I've created a table that contains the range of valid values and included this table in the query as part of an outer join. In this case, you could create a table that had times at whatever interval your currently tracking. For instance, at the half-hour mark.
-Mike