Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


About Scalar Functions


Scalar functions operate on a single value and return a single value. You can use them wherever an expression is valid.

You use scalar functions to return information from a database. You can use them in a SELECT list, a WHERE clause, a ORDER BY clause, in a stored procedure, i.e. anywhere an expression is allowed.

Scalar Functions

ABS

ASCII_CHAR

ASCII_CODE

BIT_LENGTH

CHAR_LENGTH or CHARACTER_LENGTH

CEILING

CURRENT_DATE

CURRENT_PROGRAM

CURRENT_USER

CURRENT VALUE

DACOS

DASIN

DATAN

DATAN2

DAYOFWEEK

DAYOFYEAR

DCOS

DCOT

DDEGREES

DEXP

DLOG

DLOG10

DPOWER

DRADIANS

DSIN

DSQRT

DTAN

EXTRACT

FLOOR

INDEX_CHAR

IRAND

LOCALTIME

LOCALTIMESTAMP

LOWER

MOD

NEXT VALUE

OCTET_LENGTH

PASTE

POSITION

REPEAT

REPLACE

ROUND

SESSION_USER

SIGN

SOUNDEX

SUBSTRING

TAIL

TRIM

TRUNCATE

UNICODE_CHAR

UNICODE_CODE

UPPER

USER

WEEK


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX