skip to main content
Querying data stores with SQL : Supported scalar functions : Scalar Function Support for Amazon Redshift
  

Try Now

Scalar Function Support for Amazon Redshift

The table identifies the scalar functions that Hybrid Data Pipeline supports for Amazon Redshift.
Applications connecting through JDBC or ODBC can use the following scalar functions in expressions. For syntax details, consult your JDBC or ODBC documentation.
Table 172. Scalar Functions
String Functions
Numeric Functions
Timedate Functions
System Functions
ASCII
ABS
CURDATE
DBNAME
BIT_LENGTH
ACOS
CURRENT_DATE
IFNULL
CHAR
ASIN
CURRENT_TIME
USERNAME
CHAR_LENGTH
ATAN
CURRENT_TIMESTAMP
CHARACTER_LENGTH
ATAN2
CURTIME
CONCAT
CEILING
EXTRACT
LCASE
COS
NOW
LEFT
COT
LENGTH
DEGREES
LOCATE
EXP
LTRIM
FLOOR
OCTET_LENGTH
LOG
POSITION
LOG10
REPEAT
MOD
REPLACE
PI
RIGHT
POWER
RTRIM
RADIANS
SUBSTRING
RAND
UCASE
ROUND
SIGN
SIN
SQRT
TAN
TRUNCATE