1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Functions
  3. Calculation Function Categories
  4. Date & Time Functions

Date & Time Functions

Some Essbase calculation functions help you perform calculations based on calendar dates or date-type strings.

@TODATE converts date strings to numbers that can be processed in calculation formulas.

If your cube uses date measures, you can also use the following functions.