Firebird Interne Funktionen

Aus DBWiki
Wechseln zu: Navigation, Suche

Conditional

  • CASE WHEN condition THEN result [WHEN ...] [ELSE result] END
  • CASE condition WHEN val THEN result [WHEN ...] [ELSE result] END
  • COALESCE (value[, ...])
  • IIF(condition, val1, val2)
  • NULLIF(val1,value2)

Group

  • COUNT,AVG,MIN,MAX,SUM

String

  • BIT_LENGTH(value)
  • CHAR_LENGTH(value)
  • LOWER(value)
  • OCTET_LENGTH(value)
  • SUBSTRING(str FROM start [FOR count])
  • TRIM([LEADING|TRAILING|BOTH][chars FROM] value)
  • UPPER(value)

Andere

  • CAST(value AS datatype)
  • EXTRACT(part FROM ts)