select e.event_seq,r.reg_event_seq,e.title, to_char(start_date, 'YYYY-MM-DD') f_start_date, to_char(end_date,'YYYY-MM-DD') f_end_date, e.event_type_seq, to_char(start_date, 'hh:MIam') f_start_time, to_char(end_date, 'hh:MIam') f_end_time,no_end_time,location_city,location_state
              from cal_event e,reg_event r
              where e.calendar_seq = '34'
              and r.reg_event_seq(+) = e.event_seq
              and approved = 'y'
              and (
                (trunc(e.end_date) between to_date('11/1/0','MM/DD/YYYY') and to_date('11/30/0','MM/DD/YYYY'))
                or
                (trunc(e.start_date) between to_date('11/1/0','MM/DD/YYYY') and to_date('11/30/0','MM/DD/YYYY'))
                  )
                order by start_date, end_date [nativecode=ORA-01841: (full) year must be between -4713 and +9999, and not be 0]