Events

Title

Start Date

Duration Hrs

Repeat Interval

End Date

Spanish Class

04-JAN-2009 05:00:00PM

+00 01:00:00.000000

FREQ=WEEKLY;INTERVAL=1;BYDAY=MON,WED,FRI;

11-FEB-2009

SQL Class

04-JAN-2009 05:00:00PM

+00 02:00:00.000000

FREQ=DAILY;INTERVAL=2;

1 - 2

SQL Query for Calendar

SELECT evts.title || '
' || TO_CHAR(dts.column_value,'HH:MIPM')
   || ' - ' || TO_CHAR(dts.column_value + evts.duration_hrs,'HH:MIPM') AS display,
   dts.column_value AS date_time
FROM pl_recur_events_demo evts, 
   TABLE(pl_recur.dates_pipe(evts.start_date, evts.repeat_interval, evts.end_date)) dts

September 2010

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
29	30	31	01	02 SQL Class 05:00PM - 07:00PM	03	04 SQL Class 05:00PM - 07:00PM
05	06 SQL Class 05:00PM - 07:00PM	07	08 SQL Class 05:00PM - 07:00PM	09	10 SQL Class 05:00PM - 07:00PM	11
12 SQL Class 05:00PM - 07:00PM	13	14 SQL Class 05:00PM - 07:00PM	15	16 SQL Class 05:00PM - 07:00PM	17	18 SQL Class 05:00PM - 07:00PM
19	20 SQL Class 05:00PM - 07:00PM	21	22 SQL Class 05:00PM - 07:00PM	23	24 SQL Class 05:00PM - 07:00PM	25
26 SQL Class 05:00PM - 07:00PM	27	28 SQL Class 05:00PM - 07:00PM	29	30 SQL Class 05:00PM - 07:00PM	01	02