8.47. Func About¶

8.47.1. Date Functions¶

Table 8.2. SQL and Generic Functions¶
Object	Name Description
`current_date`	The CURRENT_DATE() SQL function
`current_time`	The CURRENT_TIME() SQL function
`current_timestamp`	The CURRENT_TIMESTAMP() SQL function
`localtime`	The localtime() SQL function
`localtimestamp`	The localtimestamp() SQL function
`now`	The SQL now() datetime function

Table 8.3. SQL and Generic Functions¶
Object	Name Description
`grouping_sets`	Implement the GROUPING SETS grouping operation
`next_value`	Represent the 'next value', given a Sequence as its single argument
`rollup`	Implement the ROLLUP grouping operation

Table 8.4. SQL and Generic Functions¶
Object	Name Description
`array_agg`	Support for the ARRAY_AGG function
`count`	The ANSI COUNT aggregate function. With no arguments, emits COUNT *
`cube`	Implement the CUBE grouping operation
`cume_dist`	Implement the cume_dist hypothetical-set aggregate function
`dense_rank`	Implement the dense_rank hypothetical-set aggregate function
`max`	The SQL MAX() aggregate function
`min`	The SQL MIN() aggregate function
`mode`	Implement the mode ordered-set aggregate function
`percent_rank`	Implement the percent_rank hypothetical-set aggregate function
`percentile_cont`	Implement the percentile_cont ordered-set aggregate function
`percentile_disc`	Implement the percentile_disc ordered-set aggregate function
`random`	The RANDOM() SQL function
`rank`	Implement the rank hypothetical-set aggregate function
`sum`	The SQL SUM() aggregate function

Table 8.5. SQL and Generic Functions¶
Object	Name Description
`char_length`	The CHAR_LENGTH() SQL function
`coalesce`
`concat`	The SQL CONCAT() function, which concatenates strings

Table 8.6. System Functions¶
Object	Name Description
`current_user`	The CURRENT_USER() SQL function
`session_user`	The SESSION_USER() SQL function
`sysdate`	The SYSDATE() SQL function
`user`	The USER() SQL function

Table 8.7. Function Operations¶
Object	Name Description
`AnsiFunction`	Define a function in 'ansi' format, which doesn't render parenthesis
`Function`	Describe a named SQL function
`FunctionAsBinary`
`FunctionElement`	Base for SQL function-oriented constructs
`GenericFunction`	Define a 'generic' function
`OrderedSetAgg`	Define a function where the return type is based on the sort expression type as defined by the expression passed to the `FunctionElement.within_group()` method
`register_function`	Associate a callable with a particular func. name
`ReturnTypeFromArgs`	Define a function whose return type is the same as its arguments
`ScalarFunctionColumn`