Skip Headers
Oracle® Secure Backup Reference
Release 10.1

Part Number B14236-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

day-date

Description

The day-date placeholder identifies a day or group of days.

Syntax

day-date::=
weekday-expr | relative-weekday-expr | 
day n { each month | each quarter | each year } | year/month/day | month/day |
month/day each quarter
weekday-expr::=
[ weekday-name | weekday-aggregate | weekday-range ]...
weekday-name::=
mon•day[s] | tue•sday[s] | wed•nesday[s] | thu•rsday[s] | fri•day[s] |
sat•urday[s] | sun•day[s]
weekday-aggregate::=
daily | weekend[s] | weekday[s]
weekday-range::=
weekday-name-weekday-name
relative-weekday-expr::=
[ weekday-ordinal weekday-name ]... |
[ { weekday_name }... except weekday-ordinal ]... |
[ { weekday_name }... [ except ] { before | after } weekday-ordinal weekday-name ]...
weekday-ordinal::=
first | second | third | fourth | fifth | last

Semantics

weekday-expr

Identifies one or more weekdays independently of where they occur in a month. Weekday ranges must run from earlier to later in the week. For example, Sunday-Friday is permitted but not Thursday-Tuesday.

relative-weekday-expr

Identifies one or more weekdays based on where they occur in a month.

weekday-ordinal weekday-name

Identifies weekdays by the order in which they occur in the month.

weekday-name except weekday-ordinal

Identifies weekdays by name, but excludes those that fall within the specified order.

day-of-week [ except ] { before | after } weekday-ordinal weekday-name

Identifies specific weekdays that fall before or after another day, or weekdays except those that fall before or after another day.

day n each { month | quarter | year }

Identifies the nth ordinal day of each month, quarter, or year. There are 92 days in a quarter; day 92 is considered last even if there are fewer days in the quarter..

year/month/day

Identifies the specified day only once.

month/day

Identifies the specified day every year.

month/day each quarter

Identifies the day of the given relative month (1, 2, or 3) in every calendar quarter.

Example

Sample values include the following:

daily
Monday-Thursday Saturday
Wednesday weekends
last Saturday
second Thursday third Sunday
Thursday Friday Saturday except first
Saturday except third
Saturday Sunday after first Friday
weekdays before last Saturday
weekends except after last friday
monday wednesday except before first sunday
day 4 each month
day 31 each quarter
day 90 each year
2005/12/25
12/25
3/1 each quarter