Date and Time Functions |
Table: Date and Time Functions describes the OLAP DML date and time functions.
Date and Time Functions
| Statement | Description |
|---|---|
| ADD_MONTHS
|
Returns the date that is the specified number of months after the specified date. |
| BEGINDATE
|
Returns the beginning date of the first time period for which an expression has a non-NA value. |
| DAYOF
|
Returns an INTEGER in the range of 1 through 7, giving the day of the week on which a specified date falls.
|
| DDOF
|
Returns an INTEGER in the range of 1 through 31, giving the day of the month on which a specified date falls.
|
| ENDDATE
|
Returns the ending date of the last time period for which an expression has a non-NA value. |
| ENDOF
|
Returns the last date of a time period in dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. |
| LAST_DAY
|
Returns the last day of the month in which a particular date falls. |
| MAKEDATE
|
Returns the DATE value that corresponds to specified INTEGER values for a year, month, and day.
|
| MMOF
|
Returns an INTEGER in the range of 1 to 12, giving the month in which a specified date falls. The result returned by MMOF has the same dimensions as the specified DATE expression.
|
| MONTHS_BETWEEN
|
Calculates the number of months between two dates. |
| NEW_TIME
|
Converts a date and time from one time zone to another. |
| NEXT_DAY
|
Returns the date of the first instance of a particular day of the week that follows the specified date. |
| ROUND (for dates and time)
|
Returns a date and time value rounded to a specified date format; or, when you do not specify a format, the date and time value rounded to the nearest day. |
| STARTOF
|
Returns the starting date of a time period in a dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. |
| SYSDATE
|
Returns the current date and time in the format specified by the NLS_DATE_FORMAT option. |
| TCONVERT
|
Converts data from one dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR to another dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR. |
| TOD
|
Returns the current time of day in the form hh:mm:ss using a 24-hour format. |
| TODAY
|
Returns the current date as a DATE value. |
| TRIM
|
Returns the date and time value truncated to a specified date format; or, when you do not specify a format, returns the date and time value truncated to the nearest day. |
| VNF
|
Assigns a value name format (VNF) to the definition of a dimension with a type of DAY, WEEK, MONTH, QUARTER, or YEAR. |
| WEEKOF
|
Returns an INTEGER in the range of 1 to 53, which gives the week of the year in which a specified date falls.
|
| YYOF
|
Returns an INTEGER in the range of 1000 to 9999, giving the year in which a specified date falls.
|