Functions that the BMC AMI Utilities SQL language supports
The following topics describe the functions that the BMC AMI Utilities SQL language supports:
- BIGINT
- BINARY(binary_string_expression, length)
- CHAR
- DATE
- DAY
- DAYS
- DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- DECFLOAT
- DECIMAL or DEC
- DIGITS
- FLOAT
- HEX
- HOUR
- INTEGER or INT
- LENGTH
- LOCATE
- LOWER or LCASE
- MICROSECOND
- MINUTE
- MOD
- MONTH
- REAL
- REPEAT
- RIGHT
- SECOND
- SMALLINT
- SOUNDEX
- SUBSTR
- S370 function
- TIME
- TIMESTAMP
- TIMESTAMP_TZ
- TRANSLATE
- TRIM
- UPPER or UCASE
- VALUE/COALESCE/IF NULL
- VARBINARY(binary_string_expression, length)
- VARCHAR
- WEEK
- YEAR
- ZONED
- @ROWID function
- STRIP
Related topic
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.