Functions

Functions

1. Compile-time standard library

• String functions
  • SUBSTRING(), MID(), INSTR(), TRIM()
• Number functions
• Logical functions
• Date-time functions
  • CONVERT()
• Unique identified functions
  • NEWID(), UUID() and GEN_RANDOM_UUID()

2. Run-time standard library

• ROWNUM() (or ROW_NUMBER())
• COALESCE()

3. [User-defined functions](User-defined functions)
4. Into-functions
5. From-functions
6. Aggregators
7. [User-defined aggregators](User-defined aggregators)

Samples:

    ABS(), IIF(), IFNULL(), INSTR(), LOWER(), 
    UPPER(), LCASE(), UCASE(), LEN(), LENGTH()
    YEAR(date), DAYOFWEEK(date)

Compatibility function

• OBJECT_ID()