Netezza
- Netezza Math
- Netezza Trigonometry
- Netezza Fuzzy
- Netezza Phonetic
- ascii
Returns a number representing the ASCII code value of the leftmost character of "string_expression"; for example, ascii ( 'A' ) is 65. - chr
Returns the character that has the ASCII code value specified by "integer_expression". "Integer_expression" should be between 0 and 255. - decode
Compares "expr" to each search value one by one. If "expr" is equal to a search, then it returns the corresponding result. If no match is found, it returns "default". If "default" is omitted, it returns null. - initcap
Returns "string_expression", with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. - instr
Searches "string_expression1" starting at position "integer_expression1" for the "integer_expression2" occurrence of "string_expression2". If "integer_expression1" is negative then the search is backwards from the end of "string_expression1". Returns an integer indicating the position of "string_expression2". - lpad
Returns "string_expression1" padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. - ltrim
Returns "string_expression1", with leading characters removed up to the first character not in "string_expression2"; for example, ltrim ( 'xyxXxyAB' , 'xy' ) returns XxyAB. - months_between
Returns the number of months from "date_expression1" to "date_expression2". If "date_expression1" is later than "date_expression2" then the result will be a positive number. The days and time portions of the difference are ignored, i.e., the months are not rounded, except if "date_expression1" and "date_expression2" are the last days of a month. - next_day
Returns the datetime of the first weekday named by "string_expression" that is later than "datetime_expression". The return value has the same hours, minutes, and seconds as "datetime_expression". - nvl
Returns the value of "expression1" if "expression1" is not NULL. If "expression1" is NULL, then returns the value of "expression2". - round
Returns "numeric_expression" rounded to the nearest value "integer_expression" places 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; for example, round (125, -1) rounds to 130. - rpad
Returns "string_expression1" right-padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. If "string_expression2" is not specified, then spaces are used. - rtrim
Returns "string_expression1", with final characters removed after the last character not in "string_expression2"; for example, rtrim ( 'ABxXxyx' , 'xy' ) returns ABxX. If "string_expression2" is not specified, the final space characters are removed. - substr
Returns the substring of "string_expression" that starts at position "integer_expression1". The first character in "string_expression" is at position 1. "Integer_expression2" can be used to select fewer characters; by default it selects characters to the end of the string. - {current_db}
- {current_user}
- {session_user}
- to_char
Returns the string representation of "expression" with the format of "string_expression". "Expression" can be either a date value or a numeric value. - to_date
Converts "expression1" to a date value as specified by the format "string_expression2". The first argument "expression1" may be of type string or numeric. - to_number
Converts "string_expression1" to a numeric value as specified by the format "string_expression2". - translate
Returns "string_expression1", with all occurrences of each character in "string_expression2" replaced by its corresponding character in "string_expression3". - date_trunc
Truncates "date_expression1" to a value as specified by the format "string_expression1". - trunc
Truncates digits from "numeric_expression1" using "numeric_expression2" as the precision. - version
Returns the "string_expression1" value of the database version.
Parent topic: Using the expression editor