In addition to the default operators, the expression language supports many other scalar valued functions included in the DataFlow core library.

The library provides several functions that can provide references to known values. You can use them to combine constant values with other functions. Available functions are listed in Available Functions.

The library provides a selection of functions to convert between various datatypes. These functions are for conversions that would not normally be permitted by the token type system, as they are either possibly “lossy” (such as type narrowing) or ambiguous (such as string formatting). Available functions are listed in Available Functions.

The library provides implementations of several common date/time functions. Unless otherwise stated, functions can be applied to any of the date/time types including Date, Time, or Timestamp. Some of the functions use special enumerations that are available within the DateTime class.

Part is a string constant and must be one of the following:

Granularity is a string constant and must be one of the following:

TimeZone is a string constant. It can be given as an offset from GMT ("GMT-5", "GMT+8:30", etc.) or as a valid time zone name from the tz database ("America/Chicago", "Asia/Tokyo", "Europe/London", etc.). If no time zone is specified, the default time zone of the local machine is used. If an invalid time zone is specified, the expression will be invalid.

For the list of available functions, see Available Functions.

The library provides several implementations of common formatting functions. The format specification is defined by java.util.Formatter. Reference the java.util.Formatter documentation for the capabilities and limitations of the available formatting functions. The format specification is not validated before being used. Therefore, errors in the format specification are not discovered until execution.

Available functions are listed in Available Functions.

The library provides implementations of common math functions found in the java.lang.Math library.

All trigonometric functions use radians by default. Use the toDegrees and toRadians functions to convert between radians and degrees.

Available functions are listed in Available Functions.

The library provides implementations of several common statistical functions that can be used to calculate aggregates within a field.

Available functions are listed in Available Functions.

The library provides implementations of the common string manipulation functions.

Available functions are listed in Available Functions.