|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
DAYNAMES = name-list
A multiline text expression that lists the names of the seven days of the week. Each name occupies a separate line. Regardless of which day you are treating as the first day of the week, the list must begin with the name for Sunday. The default value is the list of English names for the days of the week, in uppercase.
You can include more than one set of seven names in your list. The eighth name is a synonym for the first name, the ninth name is a synonym for the second name, and so on.
The DAYNAMES list is consulted when you display or convert a date using the
<WTEXTL> formats. These formats are specified in the DATEFORMAT option. When you have more than one set of day names, Oracle OLAP chooses the synonym whose number of characters and capitalization pattern best match the DATEFORMAT specification.
You can set the DAYABBRLEN option to control the number of characters used for abbreviations of day names.
Example 9-35 Specifying Day Names
The following commands set DAYNAMES to the French names for the days of the week and send the output to the current outfile.
DAYNAMES = 'dimanche\nlundi\n- mardi\nmercredi\njeudi\nvendredi\nsamedi' SHOW DAYNAMES
These commands produce the following output.
dimanche lundi mardi mercredi jeudi vendredi samedi