Red Brick
- ceil
Returns the smallest integer greater than or equal to "numeric_expression" or "string_expression". Note that "string_expression" must represent a valid numeric value. - concat
Returns a string that is the result of concatenating, or joining, "string_expression1" to "string_expression2". - {current_user}
Returns the database username (authorization ID) of the current user. - date
Returns a date value. "Expression" can be either characters or a timestamp. - dateadd
Adds "interval" to "datetime_expression" and returns a result that is the same datetime data type as "datetime_expression". "Datepart" refers to the year, month, day, hour, minute, second. "Interval" must be an integer and "datetime_expression" can be a date, time, or timestamp. - datediff
Determines the difference between two datetime expressions and returns an integer result in "datepart" units. "Datepart" refers to a year, month, day, hour, minute, or second. "Datetime_expression1" and "datetime_expression2" can be dates, times, or timestamps. - datename
Extracts "datepart" of "datetime_expression" and returns its value as a character string. "Datepart" refers to a year, month, day, hour, minute, or second. "Datetime_expression" can be a date, a time, or a timestamp. - dec
Converts "expression" to a decimal value with the data type decimal (precision, scale). The default value of precision is 9. The default value of scale is 0. - decimal
Converts "expression" to a decimal value with the data type decimal (precision, scale). The default value of precision is 9. The default value of scale is 0. - decode
Compares and converts "expression" to another value. If "expression" matches "target", it is replaced, otherwise it is replaced by "default" or null if no default is specified. The expressions can be any data type as long as they are all the same data type. - float
Converts "numeric_expression" into a double-precision floating-point value. - ifnull
Tests "expression" for missing values and replaces each one with "substitute". If "expression" is null, "substitute" is returned, otherwise it returns the value of "expression". The expressions can be any data type as long as they are all the same data type. - int
Converts "numeric_expression" into an integer value and returns an integer value. If "numeric_expression" is null, it returns null. - integer
Converts "numeric_expression" into an integer value and returns an integer value. If "numeric_expression" is null, it returns null. - length
Returns an integer result specifying the number of characters in "string_expression". If "string_expression" is null, it returns null. - lengthb
Returns an integer result specifying the number of bytes in "string_expression". If "string_expression" is null, it returns null. - ltrim
Removes leading blanks from "string_expression". If "string_expression" is null, it returns null. - nullif
Returns null if both "expression1" and "expression2" have the same value. If they have different values, the value of "expression1" is returned. "Expression1" and "expression2" can be any data type as long as they are the same data type. - positionb
Returns an integer that is relative to the beginning byte position of "string_expression1" in "string_expression2". If "string_expression1" is not located, the result is 0. If "string_expression1" is of zero length, the result is 1. If "string_expression1" is null, an error message is returned. If "string_expression2" is null, the result is 0. - real
Returns a real value. If "numeric_expression" is null, it returns null. - round
Returns "numeric_expression" rounded to the nearest value "integer_expression" places to the right of the decimal point. If "integer_expression" is negative, "numeric_expression" is rounded to the nearest absolute value "integer_expression" places to the left of the decimal point. Rounding takes place before data formatting is applied. - rtrim
Removes trailing blanks from "string_expression". If "string_expression" is null, it returns null. - sign
Determines the sign of "numeric_expression", and returns 1 for a positive value, –1 for a negative value, and 0 for zero. - string
Converts "expression" to a character string. "Expression" can be either numeric or datetime. - substr
Returns a substring of "string_expression" that begins at position "start_integer" and continues for "length_integer" characters. If "length_integer" is not specified, a substring from "start_integer" to the end of "string_expression" is returned. - substrb
Returns a substring of "string_expression" that begins at position "start_integer" and continues for "length_integer" bytes. If "length_integer" is not specified, a substring from "start_integer" to the end of "string_expression" is returned. - time
Creates a time value from "expression", which can be a character string or a time-stamp data type expression. - timestamp
Creates a time-stamp value from "timestamp_expression", which is a character string. - timestamp
Creates a time-stamp value from "time_expression" and "date_expression". If either "time_expression" or "date_expression" is null, the resulting time-stamp expression is also null. - to_char
Converts "source_date" to the character string specified by "format_string". "Source_date" can be a date, time, or timestamp data type.
Parent topic: Using the expression editor