Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Function Expressions

Syntax

Any built-in can be used as an expression. The syntax for a function call is the name of a function followed by its argument list in parentheses.

Copy
function ( [expression [, expression...]] )

Arguments

function

Any built-in function.

expression

Any expression(s) matching the data type and parameter count expected by the function.

Examples

Copy
abs (variable) select avg (qtysold + 3) from sales; select dateadd (day,30,caldate) as plus30days from date;