Sybase predefined functions

1. Aggregate functions

SUM ([all|distinct] expression)

AVG ([all|distinct] expression)

Count ([all|distinct] expression)

COUNT (*)

Max (expression)

MIN (expression)

2. String functions

Upper (character expression)

Lower (character expression)

char (int-expression)

Char_length (character expression)

LTrim (character expression)

RTrim (character expression)

......

3. Mathematical functions

ABS (exact decimal type expression)

Floor (exact decimal expression) to find the largest integer (bottom) that is less than or equal to the given expression value

rand (INT-type)

Round (exact decimal expression, integer)

sign (exact decimal expression)

Power (exact decimal expressions, integer powers)

......

4. Date function

GETDATE ()

DATEPART (date part, date)

DateDiff (date part, date 1, date 2)

DATEADD (date part, numeric expression, date)

5. Type Conversion Functions

Convert (data type, expression [, format])

6. System functions

DB_NAME ([database ID])

HOST_NAME ()

IsNull (expression 1, expression 2)

......