|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The DDOF function returns an integer in the range of 1 through 31, giving the day of the month on which a specified date falls. The result returned by DDOF has the same dimensions as the specified DATE expression.
An expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to-DATE Conversion".
In place of a DATE expression, you can specify a text expression that has values that conform to a valid input style for dates. The values of the text expressions are automatically converted to DATE values using the current setting of the DATEORDER option to resolve any ambiguity.