Date and Time Options |
A number of options determine how date and time values are handled. These options are listed in Table: Date and Time Options.
Date and Time Options
| Statement | Description |
|---|---|
| CALENDARWEEK
|
Determines whether weeks should be aligned with the actual calendar year. |
| DATEFORMAT
|
Specifies the template used for displaying DATE values and converting DATE values to TEXT values.
|
| DATEORDER
|
Contains three characters that indicate the intended order of the month, day, and year components of the DATE values in a workspace for those cases in which their interpretation is ambiguous.
|
| DAYABBRLEN
|
Specifies the number of characters to use for abbreviations of day names that are stored in the DAYNAMES option. |
| DAYNAMES
|
A list of valid names for the days of the week. The names are used to display values of type DATE or to convert DATE values to text.
|
| DSECONDS
|
(Read-only) The number of seconds since January 1, 1970. |
| MONTHABBRLEN
|
The number of characters to use for abbreviations of month names that are stored in the MONTHNAMES option. |
| MONTHNAMES
|
The list of valid names for months that is used in handling values with a DATE data type and values of dimensions of type DAY, WEEK, MONTH, QUARTER, and YEAR.
|
| SECONDS
|
(Read-only) The number of seconds since January 1, 1970. |
| WEEKDAYSNEWYEAR
|
For a dimension of type WEEK, determines how many days of the new year there must be for a week to be identified as week 1 of the new year. |
| YRABSTART
|
The specific 100-year period associated with years that are read or displayed using a two-digit abbreviation. |