Browser version scriptSkip HeadersOracle Business Intelligence Publisher Report Designer's Guide Release 10.1.3.4 Part Number E12187-01

Contents Previous Next

Extended Function Support in RTF TemplatesExtended SQL and XSL FunctionsBI Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions or for extended XSL functions. Note: You cannot mix xdofx statements with XSL expressions in the same context. For example, assume you had two elements, FIRST_NAME and LAST_NAME that you wanted to concatenate into a 30-character field and right pad the field with the character "x", you could NOT use the following: INCORRECT: because concat is an XSL expression. Instead, you could use the following: CORRECT:

current_time()

minimum date_diff

Returns the minimum value of the element in the set. This function provides a method to get the difference between two dates in the given locale. The dates need to be in "yyyy-MM-dd" format. This function supports only the Gregorian calendar. The syntax is as follows: where

format is the time value for which the difference is to be calculated. Valid values are :y y y y y y y y

y - for year m - for month w - for week d - for day h - for hour mi - for minute s - for seconds ms - for milliseconds

Example: returns 1 Example: returns -14 Example: returns -7 sec_diff