Functions › Functions › Scalar Functions

Scalar Functions

►►─┬─┬─ DATE ────────┬─ (expression) ─────────────────────────────┬───────────►◄
   │ ├─ DAY ─────────┤                                            │
   │ ├─ DAYS ────────┤                                            │
   │ ├─ DIGITS ──────┤                                            │
   │ ├─ FLOAT ───────┤                                            │
   │ ├─ HEX ─────────┤                                            │
   │ ├─ HOUR ────────┤                                            │
   │ ├─ INTEGER ─────┤                                            │
   │ ├─ LENGTH ──────┤                                            │
   │ ├─ MICROSECOND ─┤                                            │
   │ ├─ MINUTE ──────┤                                            │
   │ ├─ MONTH ───────┤                                            │
   │ ├─ SECOND ──────┤                                            │
   │ ├─ TIME ────────┤                                            │
   │ ├─ VARGRAPHIC ──┤                                            │
   │ └─ YEAR ────────┘                                            │
   ├─ CHAR ─ (expression ────┬────────┬─ ) ───────────────────────┤
   │                         ├─ ,ISO ─┤                           │
   │                         ├─ ,USA ─┤                           │
   │                         ├─ ,EUR ─┤                           │
   │                         └─ ,JIS ─┘                           │
   ├─ DECIMAL ─ (expression ────┬───────────────────────────┬─ ) ─┤
   │                            └─ ,integer ─┬────────────┬─┘     │
   │                                         └─ ,integer ─┘       │
   ├─ SUBSTR ─ (string,start ────┬───────────┬─ ) ────────────────┤
   │                             └─ ,length ─┘                    │
   ├─ TIMESTAMP ─ (expression ────┬───────────────┬─ ) ───────────┤
   │                              └─ ,expression ─┘               │
   │                          ┌───────────────┐                   │
   ├─ VALUE ─ (expression ────▼─ ,expression ─┴─ ) ───────────────┤
   ├─ character-functions ────────────────────────────────────────┤
   ├─ bit-level-functions ────────────────────────────────────────┤
   ├─ byte-level-function ────────────────────────────────────────┤
   └─ xml-functions ──────────────────────────────────────────────┘

Notes:

• For details on character-functions, see Character Functions.
• For details on bit-level-functions, see Bit-Level Functions.
• For details on byte-level-functions, see Byte-Level Function.
• For details on xml-functions, see XML Functions.