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, and anywhere an expression is allowed. Functions are often used as part of a stored procedure.

Scalar Numeric Functions

ABS

ASCII_CODE

BIT_LENGTH

CHAR_LENGTH or CHARACTER_LENGTH

CEILING

CURRENT_VALUE

DACOS

DASIN

DATAN

DATAN2

DAYOFWEEK

DAYOFYEAR

DCOS

DCOT

DDEGREES

DEXP

DLOG

DLOG10

DPOWER

DRADIANS

DSIN

DSQRT

DTAN

EXTRACT

FLOOR

IRAND

MOD

NEXT_VALUE

OCTET_LENGTH

POSITION

ROUND

SIGN

TRUNCATE

UNICODE_CODE

WEEK

Scalar String Functions

ASCII_CHAR

CURRENT_PROGRAM

LOWER

PASTE

REPEAT

REPLACE

SOUNDEX

SUBSTRING

TAIL

TRIM

UNICODE_CHAR

UPPER

String Pseudo-Literals

CURRENT_USER

CURRENT_PROGRAM

SESSION_USER

USER

Datetime Pseudo-Literals

CURRENT_DATE

LOCALTIME

LOCALTIMESTAMP


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