CEILING(value)

Returns the value rounded up to the nearest whole number (no decimal component).

• expression: The value to round.

CONCAT(string_expr1, string_expr2)

Returns the string that is the concatenation of string_expr1 and string_expr2.

• string_expr1: The first string to be concatenated.
• string_expr2: The second string to be concatenated.

CONTAINS(string_expression, string_search)

Returns true if string_expression contains string_expression, otherwise returns false.

• string_expression: The string expression to search within.
• string_search: The value to search for.

DATE(datetime_offset)

Returns the current date using the specified datetime_offset.

• datetime_offset: The datetime offset to use when retrieving the current date.

DAY(datetime_date)

Returns the integer that specifies the day component of the specified date.

• datetime_date: The datetime string that specifies the date.

ENDSWITH(string_expression, string_suffix)

Returns true if string_expression ends with string_suffix, otherwise returns false.

• string_expression: The string expression to search within.
• string_suffix: The string suffix to search for.

FLOOR(value)

Returns the value rounded down to the nearest whole number (no decimal component).

• value: The value to round.

FRACTIONALSECONDS(datetime_time)

Returns the decimal value that specifies the fractional seconds component of the specified time.

• datetime_time: The datetime string that specifies the time.

HOUR(datetime_time)

Returns the integer that specifies the hour component of the specified time.

• datetime_time: The datetime string that specifies the time.

INDEXOF(string_expression, string_search)

Returns the index location where string_search is contained within string_expression.

• string_expression: The string expression to search within.
• string_search: The search value to locate within string_expression.

ISOF(string_expression, string_type)

Returns true if the string_expression is assignable to type string_type, otherwise returns false.

• string_expression: The string expression to check the type of.
• string_type: The name of the type.

LENGTH(string_expression)

Returns the number of characters of the specified string expression.

• string_expression: The string expression.

MAXDATETIME()

Returns the latest possible datetime.

MINDATETIME()

Returns the earliest possible datetime.

MINUTE(datetime_time)

Returns the integer that specifies the minute component of the specified time.

• datetime_time: The datetime string that specifies the time.

MONTH(datetime_date)

Returns the integer that specifies the month component of the specified date.

• datetime_date: The datetime string that specifies the date.

NOW()

Returns the current datetime.

REPLACE(string_expression, string_search, string_replace)

Returns the string after replacing any found string_search values with string_replace.

• string_expression: The string expression to perform a replace on.
• string_search: The string value to find within string_expression.
• string_replace: The string value replace and string_search instances found.

ROUND(value)

Returns the value to the nearest whole number (no decimal component).

• value: The value to round.

SECOND(datetime_time)

Returns the integer that specifies the second component of the specified time.

• datetime_time: The datetime string that specifies the time.

STARTSWITH(string_expression, string_prefix)

Returns true if string_expression starts with string_prefix, otherwise returns false.

• string_expression: The string expression to search within.
• string_prefix: The string prefix to search for.

SUBSTRING(string_expression, integer_start [,integer_length])

Returns the part of the string with the specified length; starts at the specified index.

• expression: The character string.
• start: The positive integer that specifies the start index of characters to return.
• length: The positive integer that specifies how many characters will be returned.

SUBSTRINGOF(string_expression, string_search)

Returns true if string_expression contains string_expression, otherwise returns false.

• string_expression: The string expression to search within.
• string_search: The value to search for.

TIME(datetime_offset)

Returns the current time using datetime_offset.

• datetime_offset: The datetime offset.

TOLOWER(string_expression)

Returns the string_expression with the uppercase character data converted to lowercase.

• string_expression: The string expression to lowercase.

TOTALOFFSETMINUTES(datetime_date)

Returns the integer that specifies the offset minutes component of the specified date.

• datetime_date: The datetime string that specifies the date.

TOTALSECONDS(duration)

Returns the duration value in total seconds.

• string_duration: The duration.

TOUPPER(string_expression)

Returns the string_expression with the lowercase character data converted to uppercase.

• string_expression: The string expression to uppercase.

TRIM(string_expression)

Returns the string_expression with the leading and trailing whitespace removed.

• string_expression: The string expression to trim.

YEAR(datetime_date)

Returns the integer that specifies the year component of the specified date.

• datetime_date: The datetime string that specifies the date.