I have column called time_interval the format is 'dd/mm/yyyy hh24:mi:ss'
every day the data will be coming in , for every hour, min, sec
some days the data will be missing ..
here i want to write select statement to find the missing hours in a give day .
or missing hours for a given interval period of month
like i want to find the missing hours
for the month '01-Feb-2007 :00:00:00 to 28-Feb-2007 :23:00:00'
so it should display all the missing hours of that particular month.
Please assist ,
Thanks in Advance