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. |
