Download Mimer SQL Reference Manual - Department of Information Technology

SQL language elements
5-9
TRUNCATE
Returns the given numeric expression truncated to a number
of places to the right of the decimal point specified by a given
integer expression. If the integer expression is negative, the
numeric expression is truncated to a number of places to the
left of the decimal point specified by the absolute value of the
integer expression.
WEEK
Returns the week of the year for the given date expression,
expressed as an integer value in the range 1-53.
Scalar string functions
Result
ASCII_CHAR
Returns the character that has the given ASCII code value.
The given ASCII code value should be in the range 0-255.
CURRENT_PROGRAM
Returns the name of a entered program.
LOWER
Converts all uppercase letters in a character string to
lowercase.
PASTE
Returns a character string where a specified number of
characters, beginning at a given position, have been deleted
from a character string and replaced with a given string
expression.
REPEAT
Returns a character string composed of a specified string
expression repeated a given number of times.
REPLACE
Replaces all occurrences of a given string expression with
another string expression in a character string.
SOUNDEX
Returns a character string value containing six digits that
represent an encoding of the sound of the given string
expression.
SUBSTRING
Extracts a substring from a given string, according to
specified start position and length of the substring.
TAIL
Returns the specified number of rightmost characters in a
given character string.
TRIM
Removes leading and/or trailing instances of a specified
character from a string.
UPPER
Converts all lowercase letters in a character string to
uppercase.
Scalar interval functions
Result
ABS
Returns the absolute value of the given interval expression.
Datetime “pseudo literals”
Result
CURRENT_DATE
Returns a DATE value denoting the current date (i.e. “today”).
LOCALTIME
Returns a TIME value denoting the current time (i.e. “now”).
LOCALTIMESTAMP
Returns a TIMESTAMP denoting the current date and time.
Mimer SQL version 8.2
Reference Manual