Teradata

Teradata Trigonometry
account
Returns the account string for the current user.
add_months
Returns the date or the datetime resulting from adding "integer_expression" months to "date_expression" or "datetime_expression".
bytes
Returns the number of bytes contained in "byte_expression". "Byte_expression" is restricted to BYTE or VARBYTE.
case_n
Evaluates "condition_expression_list" and returns the position of the first true condition, provided that no prior condition in the list evaluates to unknown. The keywords must be enclosed in curly brackets. No case is an optional condition that evaluates to true if every expression in the list evaluates to false. No case or unknown is an optional condition that evaluates to true if every expression in the list evaluates to false, or if an expression evaluates to unknown and all prior conditions in the list evaluate to false. Unknown is an optional condition that evaluates to true if an expression evaluates to unknown and all prior conditions in the list evaluate to false.
char2hexint
Returns the hexadecimal representation for "string_expression".
characters
Returns an integer value representing the number of logical characters or bytes contained in "string_expression".
database
Returns the name of the default database for the current user.
date
Returns the current date.
format
Returns the declared format for "expression" as a variable character string of up to 30 characters.
index
Returns the starting position of "string_expression2" in "string_expression1".
log
Computes the base 10 logarithm of "numeric_expression". "Numeric_expression" must be a non-zero, positive, numeric expression.
nullif
Returns null if "scalar_expression1" and "scalar_expression2" are equal. Otherwise, it returns "scalar_expression1". "Scalar_expression1" and "scalar_expression2" can be any data type.
nullifzero
If "numeric_expression" is zero, converts it to null to avoid division by zero.
profile
Returns the current profile for the session or null if none.
random
Returns a random integer number for each row of the results table. "Lower_bound" and "upper_bound" are integer constants. The limits for "lower_bound" and "upper_bound" range from -2147483648 to 2147483647 inclusive. "Upper_bound" must be greater than or equal to "lower_bound".
role
Returns the current role for the session or null if none.
session
Returns the number of the session for the current user.
soundex
Returns a character string that represents the Soundex code for "string_expression".
substr
Returns the substring of "string_expression" that starts at position "integer_expression1" for "integer_expression2" characters. The first character in "string_expression" is at position 1. If "integer_expression2" is omitted, returns the substring of "string_expression" that starts at position "integer_expression1" and ends at the end of "string_expression".
time
Returns the current time based on a 24-hour day. According to Teradata documentation, the system function TIME is deprecated. Use CURRENT_TIME function instead. Please note that in Compatible Mode TIME returns time data type, while in Dynamic Query Mode time returns a value of type FLOAT.
type
Returns the data type defined for "expression".
user
Returns the user name of the current user.
vargraphic
Returns a character string that represents the vargraphic code for "string_expression".
zeroifnull
Converts data from null to 0 to avoid errors created by a null value. If "numeric_expression" is not null, returns the value of "numeric_expression". If "numeric_expression" is a character string, it is converted to a numeric value of float data type. If "numeric_expression" is null or zero, it returns zero.

Parent topic: Using the expression editor