1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
|
-- --------------------------------------------------------------------
-- This file is a set of tests for the RRULE sql functions taken from
-- the examples in RFC2445 section 4.8.5.4
-- --------------------------------------------------------------------
-- --------------------------------------------------------------------
-- Daily for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=DAILY;COUNT=10
--
-- ==> (1997 9:00 AM EDT)September 2-11
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=DAILY;COUNT=10' );
--
-- --------------------------------------------------------------------
-- Daily until December 24, 1997:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=DAILY;UNTIL=19971224T000000Z
--
-- ==> (1997 9:00 AM EDT)September 2-30;October 1-25
-- (1997 9:00 AM EST)October 26-31;November 1-30;December 1-23
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=DAILY;UNTIL=19971224T000000' );
--
-- --------------------------------------------------------------------
-- Every other day - forever:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=DAILY;INTERVAL=2
-- ==> (1997 9:00 AM EDT)September2,4,6,8...24,26,28,30;
-- October 2,4,6...20,22,24
-- (1997 9:00 AM EST)October 26,28,30;November 1,3,5,7...25,27,29;
-- Dec 1,3,...
--
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=DAILY;INTERVAL=2' ) LIMIT 50;
-- --------------------------------------------------------------------
-- Every 10 days, 5 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=DAILY;INTERVAL=10;COUNT=5
--
-- ==> (1997 9:00 AM EDT)September 2,12,22;October 2,12
--
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=DAILY;INTERVAL=10;COUNT=5' );
-- --------------------------------------------------------------------
-- Everyday in January, for 3 years:
--
-- DTSTART;TZID=US-Eastern:19980101T090000
-- RRULE:FREQ=YEARLY;UNTIL=20000131T090000Z;
-- BYMONTH=1;BYDAY=SU,MO,TU,WE,TH,FR,SA
-- or
-- RRULE:FREQ=DAILY;UNTIL=20000131T090000Z;BYMONTH=1
--
-- ==> (1998 9:00 AM EDT)January 1-31
-- (1999 9:00 AM EDT)January 1-31
-- (2000 9:00 AM EDT)January 1-31
--
--- ? No instance on January 31, since 9:00am EDT is after 2000-01-31 09:00:00 UTC. I think that is correct.
--- ? SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19980101T090000', 'FREQ=YEARLY;UNTIL=20000131T090000Z;BYMONTH=1;BYDAY=SU,MO,TU,WE,TH,FR,SA' );
--- ? No instance on January 31, since 9:00am EDT is after 2000-01-31 09:00:00 UTC. I think that is correct.
--- ? SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19980101T090000', 'FREQ=DAILY;UNTIL=20000131T090000Z;BYMONTH=1' );
-- --------------------------------------------------------------------
-- Weekly for 10 occurrences
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;COUNT=10
--
-- ==> (1997 9:00 AM EDT)September 2,9,16,23,30;October 7,14,21
-- (1997 9:00 AM EST)October 28;November 4
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;COUNT=10' );
--
-- --------------------------------------------------------------------
-- Weekly until December 24, 1997
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;UNTIL=19971224T000000Z
--
-- ==> (1997 9:00 AM EDT)September 2,9,16,23,30;October 7,14,21
-- (1997 9:00 AM EST)October 28;November 4,11,18,25;
-- December 2,9,16,23
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;UNTIL=19971224T000000Z' );
--
-- --------------------------------------------------------------------
-- Every other week - forever:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;INTERVAL=2;WKST=SU
--
-- ==> (1997 9:00 AM EDT)September 2,16,30;October 14
-- (1997 9:00 AM EST)October 28;November 11,25;December 9,23
-- (1998 9:00 AM EST)January 6,20;February 3, 17
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;INTERVAL=2;WKST=SU' ) LIMIT 13;
--
-- --------------------------------------------------------------------
-- Weekly on Tuesday and Thursday for 5 weeks:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;UNTIL=19971007T000000Z;WKST=SU;BYDAY=TU,TH
-- or
-- RRULE:FREQ=WEEKLY;COUNT=10;WKST=SU;BYDAY=TU,TH
--
-- ==> (1997 9:00 AM EDT)September 2,4,9,11,16,18,23,25,30;October 2
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;UNTIL=19971007T000000Z;WKST=SU;BYDAY=TU,TH' );
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;COUNT=10;WKST=SU;BYDAY=TU,TH' );
--
-- --------------------------------------------------------------------
-- Every other week on Monday, Wednesday and Friday until December 24,
-- 1997, but starting on Tuesday, September 2, 1997:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;INTERVAL=2;UNTIL=19971224T000000Z;WKST=SU;
-- BYDAY=MO,WE,FR
-- ==> (1997 9:00 AM EDT)September 2,3,5,15,17,19,29;October
-- 1,3,13,15,17
-- (1997 9:00 AM EST)October 27,29,31;November 10,12,14,24,26,28;
-- December 8,10,12,22
-- !!! This is challenging, because it starts on DTSTART even though DTSTART fails the repeat criteria. In fact no known provide a UI that allows data like this to be created.
--- !!! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;INTERVAL=2;UNTIL=19971224T000000Z;WKST=SU;BYDAY=MO,WE,FR' );
--
-- --------------------------------------------------------------------
-- Every other week on Tuesday and Thursday, for 8 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=WEEKLY;INTERVAL=2;COUNT=8;WKST=SU;BYDAY=TU,TH
--
-- ==> (1997 9:00 AM EDT)September 2,4,16,18,30;October 2,14,16
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=WEEKLY;INTERVAL=2;COUNT=8;WKST=SU;BYDAY=TU,TH' );
--
-- --------------------------------------------------------------------
-- Monthly on the 1st Friday for ten occurrences:
--
-- DTSTART;TZID=US-Eastern:19970905T090000
-- RRULE:FREQ=MONTHLY;COUNT=10;BYDAY=1FR
--
-- ==> (1997 9:00 AM EDT)September 5;October 3
-- (1997 9:00 AM EST)November 7;Dec 5
-- (1998 9:00 AM EST)January 2;February 6;March 6;April 3
-- (1998 9:00 AM EDT)May 1;June 5
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970905T090000', 'FREQ=MONTHLY;COUNT=10;BYDAY=1FR' );
--
-- --------------------------------------------------------------------
-- Monthly on the 1st Friday until December 24, 1997:
--
-- DTSTART;TZID=US-Eastern:19970905T090000
-- RRULE:FREQ=MONTHLY;UNTIL=19971224T000000Z;BYDAY=1FR
--
-- ==> (1997 9:00 AM EDT)September 5;October 3
-- (1997 9:00 AM EST)November 7;December 5
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970905T090000', 'FREQ=MONTHLY;UNTIL=19971224T000000Z;BYDAY=1FR' );
--
-- --------------------------------------------------------------------
-- Every other month on the 1st and last Sunday of the month for 10
-- occurrences:
--
-- DTSTART;TZID=US-Eastern:19970907T090000
-- RRULE:FREQ=MONTHLY;INTERVAL=2;COUNT=10;BYDAY=1SU,-1SU
--
-- ==> (1997 9:00 AM EDT)September 7,28
-- (1997 9:00 AM EST)November 2,30
-- (1998 9:00 AM EST)January 4,25;March 1,29
-- (1998 9:00 AM EDT)May 3,31
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970907T090000', 'FREQ=MONTHLY;INTERVAL=2;COUNT=10;BYDAY=1SU,-1SU' );
--
-- --------------------------------------------------------------------
-- Monthly on the second to last Monday of the month for 6 months:
--
-- DTSTART;TZID=US-Eastern:19970922T090000
-- RRULE:FREQ=MONTHLY;COUNT=6;BYDAY=-2MO
--
-- ==> (1997 9:00 AM EDT)September 22;October 20
-- (1997 9:00 AM EST)November 17;December 22
-- (1998 9:00 AM EST)January 19;February 16
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=MONTHLY;COUNT=6;BYDAY=-2MO' );
--
-- --------------------------------------------------------------------
-- Monthly on the third to the last day of the month, forever:
--
-- DTSTART;TZID=US-Eastern:19970928T090000
-- RRULE:FREQ=MONTHLY;BYMONTHDAY=-3
--
-- ==> (1997 9:00 AM EDT)September 28
-- (1997 9:00 AM EST)October 29;November 28;December 29
-- (1998 9:00 AM EST)January 29;February 26
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=MONTHLY;BYMONTHDAY=-3' ) LIMIT 6;
--
-- --------------------------------------------------------------------
-- Monthly on the 2nd and 15th of the month for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=MONTHLY;COUNT=10;BYMONTHDAY=2,15
--
-- ==> (1997 9:00 AM EDT)September 2,15;October 2,15
-- (1997 9:00 AM EST)November 2,15;December 2,15
-- (1998 9:00 AM EST)January 2,15
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=MONTHLY;COUNT=10;BYMONTHDAY=2,15' );
--
-- --------------------------------------------------------------------
-- Monthly on the first and last day of the month for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970930T090000
-- RRULE:FREQ=MONTHLY;COUNT=10;BYMONTHDAY=1,-1
--
-- ==> (1997 9:00 AM EDT)September 30;October 1
-- (1997 9:00 AM EST)October 31;November 1,30;December 1,31
-- (1998 9:00 AM EST)January 1,31;February 1
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970930T090000', 'FREQ=MONTHLY;COUNT=10;BYMONTHDAY=1,-1' );
--
-- --------------------------------------------------------------------
-- Every 18 months on the 10th thru 15th of the month for 10
-- occurrences:
--
-- DTSTART;TZID=US-Eastern:19970910T090000
-- RRULE:FREQ=MONTHLY;INTERVAL=18;COUNT=10;BYMONTHDAY=10,11,12,13,14,
-- 15
--
-- ==> (1997 9:00 AM EDT)September 10,11,12,13,14,15
-- (1999 9:00 AM EST)March 10,11,12,13
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970910T090000', 'FREQ=MONTHLY;INTERVAL=18;COUNT=10;BYMONTHDAY=10,11,12,13,14,15' );
--
-- --------------------------------------------------------------------
-- Every Tuesday, every other month:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=MONTHLY;INTERVAL=2;BYDAY=TU
--
-- ==> (1997 9:00 AM EDT)September 2,9,16,23,30
-- (1997 9:00 AM EST)November 4,11,18,25
-- (1998 9:00 AM EST)January 6,13,20,27;March 3,10,17,24,31
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=MONTHLY;INTERVAL=2;BYDAY=TU' ) LIMIT 18;
--
-- --------------------------------------------------------------------
-- Yearly in June and July for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970610T090000
-- RRULE:FREQ=YEARLY;COUNT=10;BYMONTH=6,7
-- ==> (1997 9:00 AM EDT)June 10;July 10
-- (1998 9:00 AM EDT)June 10;July 10
-- (1999 9:00 AM EDT)June 10;July 10
-- (2000 9:00 AM EDT)June 10;July 10
-- (2001 9:00 AM EDT)June 10;July 10
-- Note: Since none of the BYDAY, BYMONTHDAY or BYYEARDAY components
-- are specified, the day is gotten from DTSTART
--- !!! We miss the first instance in June. Busted.
--- !!! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970610T090000', 'FREQ=YEARLY;COUNT=10;BYMONTH=6,7' );
--
-- --------------------------------------------------------------------
-- Every other year on January, February, and March for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970310T090000
-- RRULE:FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3
--
-- ==> (1997 9:00 AM EST)March 10
-- (1999 9:00 AM EST)January 10;February 10;March 10
-- (2001 9:00 AM EST)January 10;February 10;March 10
-- (2003 9:00 AM EST)January 10;February 10;March 10
--- !!! We miss the first instance in March. Busted.
--- !!! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970310T090000', 'FREQ=YEARLY;INTERVAL=2;COUNT=10;BYMONTH=1,2,3' );
--
-- --------------------------------------------------------------------
-- Every 3rd year on the 1st, 100th and 200th day for 10 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970101T090000
-- RRULE:FREQ=YEARLY;INTERVAL=3;COUNT=10;BYYEARDAY=1,100,200
--
-- ==> (1997 9:00 AM EST)January 1
-- (1997 9:00 AM EDT)April 10;July 19
-- (2000 9:00 AM EST)January 1
-- (2000 9:00 AM EDT)April 9;July 18
-- (2003 9:00 AM EST)January 1
-- (2003 9:00 AM EDT)April 10;July 19
-- (2006 9:00 AM EST)January 1
--- ! We don't support BYYEARDAY yet.
--- ! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970101T090000', 'FREQ=YEARLY;INTERVAL=3;COUNT=10;BYYEARDAY=1,100,200' );
--
-- --------------------------------------------------------------------
-- Every 20th Monday of the year, forever:
-- DTSTART;TZID=US-Eastern:19970519T090000
-- RRULE:FREQ=YEARLY;BYDAY=20MO
--
-- ==> (1997 9:00 AM EDT)May 19
-- (1998 9:00 AM EDT)May 18
-- (1999 9:00 AM EDT)May 17
-- ...
--- ! We don't support BYDAY for yearly events. We don't support YEARLY at all well, TBH
--- ! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970519T090000', 'FREQ=YEARLY;BYDAY=20MO' ) LIMIT 3;
--
-- --------------------------------------------------------------------
-- Monday of week number 20 (where the default start of the week is
-- Monday), forever:
--
-- DTSTART;TZID=US-Eastern:19970512T090000
-- RRULE:FREQ=YEARLY;BYWEEKNO=20;BYDAY=MO
--
-- ==> (1997 9:00 AM EDT)May 12
-- (1998 9:00 AM EDT)May 11
-- (1999 9:00 AM EDT)May 17
-- ...
--- ! We don't support BYWEEKNO at all yet.
--- ! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970512T090000', 'FREQ=YEARLY;BYWEEKNO=20;BYDAY=MO' ) LIMIT 3;
--
-- --------------------------------------------------------------------
-- Every Thursday in March, forever:
--
-- DTSTART;TZID=US-Eastern:19970313T090000
-- RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=TH
--
-- ==> (1997 9:00 AM EST)March 13,20,27
-- (1998 9:00 AM EST)March 5,12,19,26
-- (1999 9:00 AM EST)March 4,11,18,25
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970313T090000', 'FREQ=YEARLY;BYMONTH=3;BYDAY=TH' ) LIMIT 11;
--
-- --------------------------------------------------------------------
-- Every Thursday, but only during June, July, and August, forever:
--
-- DTSTART;TZID=US-Eastern:19970605T090000
-- RRULE:FREQ=YEARLY;BYDAY=TH;BYMONTH=6,7,8
--
-- ==> (1997 9:00 AM EDT)June 5,12,19,26;July 3,10,17,24,31;
-- August 7,14,21,28
-- (1998 9:00 AM EDT)June 4,11,18,25;July 2,9,16,23,30;
-- August 6,13,20,27
-- (1999 9:00 AM EDT)June 3,10,17,24;July 1,8,15,22,29;
-- August 5,12,19,26
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970605T090000', 'FREQ=YEARLY;BYDAY=TH;BYMONTH=6,7,8' ) LIMIT 39;
--
-- --------------------------------------------------------------------
-- Every Friday the 13th, forever:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- EXDATE;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=MONTHLY;BYDAY=FR;BYMONTHDAY=13
--
-- ==> (1998 9:00 AM EST)February 13;March 13;November 13
-- (1999 9:00 AM EDT)August 13
-- (2000 9:00 AM EDT)October 13
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=MONTHLY;BYDAY=FR;BYMONTHDAY=13' ) LIMIT 35;
--
-- --------------------------------------------------------------------
-- The first Saturday that follows the first Sunday of the month,
-- forever:
--
-- DTSTART;TZID=US-Eastern:19970913T090000
-- RRULE:FREQ=MONTHLY;BYDAY=SA;BYMONTHDAY=7,8,9,10,11,12,13
--
-- ==> (1997 9:00 AM EDT)September 13;October 11
-- (1997 9:00 AM EST)November 8;December 13
-- (1998 9:00 AM EST)January 10;February 7;March 7
-- (1998 9:00 AM EDT)April 11;May 9;June 13...
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970913T090000', 'FREQ=MONTHLY;BYDAY=SA;BYMONTHDAY=7,8,9,10,11,12,13' ) LIMIT 10;
--
-- --------------------------------------------------------------------
-- Every four years, the first Tuesday after a Monday in November,
-- forever (U.S. Presidential Election day):
--
-- DTSTART;TZID=US-Eastern:19961105T090000
-- RRULE:FREQ=YEARLY;INTERVAL=4;BYMONTH=11;BYDAY=TU;BYMONTHDAY=2,3,4,
-- 5,6,7,8
--
-- ==> (1996 9:00 AM EST)November 5
-- (2000 9:00 AM EST)November 7
-- (2004 9:00 AM EST)November 2
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19961105T090000', 'FREQ=YEARLY;INTERVAL=4;BYMONTH=11;BYDAY=TU;BYMONTHDAY=2,3,4,5,6,7,8' ) LIMIT 6;
--
-- --------------------------------------------------------------------
-- The 3rd instance into the month of one of Tuesday, Wednesday or
-- Thursday, for the next 3 months:
--
-- DTSTART;TZID=US-Eastern:19970904T090000
-- RRULE:FREQ=MONTHLY;COUNT=3;BYDAY=TU,WE,TH;BYSETPOS=3
--
-- ==> (1997 9:00 AM EDT)September 4;October 7
-- (1997 9:00 AM EST)November 6
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970904T090000', 'FREQ=MONTHLY;COUNT=3;BYDAY=TU,WE,TH;BYSETPOS=3' );
--
-- --------------------------------------------------------------------
-- The 2nd to last weekday of the month:
--
-- DTSTART;TZID=US-Eastern:19970929T090000
-- RRULE:FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-2
--
-- ==> (1997 9:00 AM EDT)September 29
-- (1997 9:00 AM EST)October 30;November 27;December 30
-- (1998 9:00 AM EST)January 29;February 26;March 30
-- ...
--- SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970929T090000', 'FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-2' ) LIMIT 8;
--
-- --------------------------------------------------------------------
-- Every 3 hours from 9:00 AM to 5:00 PM on a specific day:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=HOURLY;INTERVAL=3;UNTIL=19970902T170000Z
--
-- ==> (September 2, 1997 EDT)09:00,12:00,15:00
--- !! FREQ=HOURLY Not implemented
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=HOURLY;INTERVAL=3;UNTIL=19970902T170000Z' );
--
-- --------------------------------------------------------------------
-- Every 15 minutes for 6 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=MINUTELY;INTERVAL=15;COUNT=6
--
-- ==> (September 2, 1997 EDT)09:00,09:15,09:30,09:45,10:00,10:15
--- !! FREQ=MINUTELY Not implemented
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('', '' );
--
-- --------------------------------------------------------------------
-- Every hour and a half for 4 occurrences:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=MINUTELY;INTERVAL=90;COUNT=4
--
-- ==> (September 2, 1997 EDT)09:00,10:30;12:00;13:30
--- !! FREQ=HOURLY Not implemented
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('', '' );
--
-- --------------------------------------------------------------------
-- Every 20 minutes from 9:00 AM to 4:40 PM every day:
--
-- DTSTART;TZID=US-Eastern:19970902T090000
-- RRULE:FREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16;BYMINUTE=0,20,40
-- or
-- RRULE:FREQ=MINUTELY;INTERVAL=20;BYHOUR=9,10,11,12,13,14,15,16
--
-- ==> (September 2, 1997 EDT)9:00,9:20,9:40,10:00,10:20,
-- ... 16:00,16:20,16:40
-- (September 3, 1997 EDT)9:00,9:20,9:40,10:00,10:20,
-- ...16:00,16:20,16:40
-- ...
--- !! FREQ=MINUTELY and/or BYHOUR Not implemented
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970902T090000', 'FREQ=DAILY;BYHOUR=9,10,11,12,13,14,15,16;BYMINUTE=0,20,40' ) LIMIT 500;
--
-- --------------------------------------------------------------------
-- An example where the days generated makes a difference because of
-- WKST:
--
-- DTSTART;TZID=US-Eastern:19970805T090000
-- RRULE:FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=MO
--
-- ==> (1997 EDT)Aug 5,10,19,24
--
-- changing only WKST from MO to SU, yields different results...
--
-- DTSTART;TZID=US-Eastern:19970805T090000
-- RRULE:FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU
-- ==> (1997 EDT)August 5,17,19,31
--
--- !! WKST Not implemented. The second one works fine because WKST == SU in all our code.
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970805T090000', 'FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=MO' );
--- !! SET timezone TO 'US/Eastern'; SELECT * FROM event_instances('19970805T090000', 'FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=TU,SU;WKST=SU' );
--
|
