Example Query
select * from table(rtd.APTlistOfDates(to_Date('10012008','MMDDYYYY'), to_date('10032008','MMDDYYYY'), 11))
The output from this example:
THE_DATE -------------------- 01-Oct-2008 00:00:00 02-Oct-2008 00:00:00 03-Oct-2008 00:00:00
The third argument--groupBy--controls the granularity of the results, as follows:
Value | Description |
|---|---|
1 | Group by 15 minutes |
2 | Group by 30 minutes |
3 | Group by 5 minutes. |
4 | Group by 10 minutes. |
5 | Group by 1 minute. |
10 | Group by hour |
11 | Group by day |
12 | Group by week |
13 | Group by month |
14 | Group by quarter |
15 | Group by year |