Example Query
SELECT start_date, finish_date
FROM TABLE(rtd.LISTOFBACKUPWINDOWDATES(TO_DATE('01012008','MMDDYYYY'), to_DATE('01072008','MMDDYYYY'),
apt_BackupWindowListType(
APT_BACKUPWINDOWTYPE('Mon', 40, 64),
APT_BACKUPWINDOWTYPE('Tue', 64, 88),
APT_BACKUPWINDOWTYPE('Wed', 88, 112),
APT_BACKUPWINDOWTYPE('Thu', 112, 136),
APT_BACKUPWINDOWTYPE('Fri', 136, 160),
APT_BACKUPWINDOWTYPE('Sat', 160, 184),
APT_BACKUPWINDOWTYPE('Sun', 16, 40)
)
))The output from this example:
12/31/2007 4:00:00 PM1/1/2008 3:59:59 PM 1/1/2008 4:00:00 PM1/2/2008 3:59:59 PM 1/2/2008 4:00:00 PM1/3/2008 3:59:59 PM 1/3/2008 4:00:00 PM1/4/2008 3:59:59 PM 1/4/2008 4:00:00 PM1/5/2008 3:59:59 PM 1/5/2008 4:00:00 PM1/6/2008 3:59:59 PM 1/6/2008 4:00:00 PM1/7/2008 3:59:59 PM