Greenplum
- Greenplum String
- Greenplum Data type formatting
- Greenplum Math
- Greenplum Trigonometry
- 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. - current_database
Returns the name of the current database. - current_schema
Returns the name of the current schema. - {current_user}
- {session_user}
- translate
Returns "string_expression1" with each occurrence of each character in "string_expression2" replaced by its corresponding character in "string_expression3". - date_trunc
Returns the timestamp to the specified precision. - version
Returns the string value of the database version.
Parent topic: Using the expression editor