A QUERY FOR TWO DIFFERENT DATE AND TIMES BETWEEN TWO DATES

Select (To_Date(Decode('01/MAY/2013', '', '01/Jan/1910', '01/MAY/2013') ||
                                                ' 0001',
                                                'DD-MON-YYYY HH24MI')) +
                                       (Rownum - 1) / 24 FromDate,
                                       (To_Date(Decode('31/MAY/2013', '', '31/Dec/9990', '31/MAY/2013') ||
                                                ' 0000',
                                                'DD-MON-YYYY HH24MI')) +
                                       (Rownum / 24) ToDate,
                                       'F' Type,
                                       'XXXX' Operator,
                                       '' FlightNature
                                  From tab
                                 Where Rownum <= 24