Full list of functions supported by Arcgis GDB file geodatabases, Shapefiles, coverages, and other file-based data sources

Function

The following is a complete list of the functions supported by file geodatabases, Shapefiles, coverages, and other file-based data sources. These functions are also supported by personal and ArcSDE geodatabases, but these data sources may use different syntax or function names. In addition to these functions, personal geodatabases and ArcSDE geodatabases support some other features. For more information, see your DBMS documentation.

Date function

function	description
current_date	returns the current date.
extract (Extract_field from Extract_source)	returns Extract_source The extract_field section. The extract_source parameter is a date-time expression. The Extract_field parameter can be any of the following keywords: year, MONTH, Day, HOUR, MINUTE, or SECOND.
current time	Returns the current time.

Date FunctionString functions

A parameter represented by String_exp can be the result of a column name, a string literal, or another scalar function whose underlying data type can be represented as a character type.

The argument represented by Character_exp is a variable-length character string.

A parameter in start or length can be the result of a numeric literal or another scalar function whose underlying data type can be represented as a numeric type.

These string functions are based on 1; that is, the first character of a string is character 1.

Function	Describe
Char_length(STRING_EXP)	Returns the character length of a string expression.
CONCAT(STRING_EXP1, STRING_EXP2)	Returns the string that is obtained after the string_exp2 is connected to the string_exp1 .
LOWER(STRING_EXP)	Returns a string equal to string_exp , where all uppercase characters are converted to lowercase characters.
POSITION(character_exp in character_exp)	Returns the position of the first character expression in a second character expression. The result is an exact value, with a predefined precision and a decimal number of zero.
SUBSTRING (String_exp from start for length)	Returns a string derived from String_exp whose starting character position is specified by start and the number of characters specified by length .
TRIM(BOTH | Leading | TRAILING trim_character from string_exp)	Returns the String_expfrom the beginning, end, or both ends of a string when trim_character is removed.
UPPER(STRING_EXP)	Returns a string equal to string_exp , where all lowercase characters are converted to uppercase characters.

String Functionsnumeric functions

All numeric functions return numeric values.

A parameter represented by Numeric_exp,float_exp , or integer_exp can be a column name, a result of another scalar function, or a numeric literal whose underlying data type can be represented as numeric.

Function	Describe
ABS(NUMERIC_EXP)	Returns the absolute value of the numeric_exp .
ACOS(FLOAT_EXP)	Returns the inverse cosine of the float_exp as an angle, expressed in radians.
ASIN(FLOAT_EXP)	Returns the inverse chord value of the float_exp as an angle, expressed in radians.
ATAN(FLOAT_EXP)	Returns the inverse tangent of the float_exp as an angle, expressed in radians.
CEILING(NUMERIC_EXP)	Returns the smallest integer greater than or equal to numeric_exp .
COS(FLOAT_EXP)	Returns the cosine of the float_exp , where float_exp is the angle in radians.
Floor(NUMERIC_EXP)	Returns the largest integer less than or equal to numeric_exp .
LOG(FLOAT_EXP)	Returns the natural logarithm of the float_exp .
LOG10(FLOAT_EXP)	Returns the base 10 logarithm of the float_exp .
MOD(INTEGER_EXP1, INTEGER_EXP2)	Returns the remainder of integer_exp1 divided by integer_exp2 .
POWER(Numeric_exp, Integer_exp)	Returns the value of the integer_exp power of the numeric_exp .
ROUND(Numeric_exp, Integer_exp)	Returns the numeric_exprounded to the integer_exp bit to the right of the decimal point. If integer_exp is negative, numeric_exp will be rounded to the left of the decimal point | Integer_exp| -bit
Sign(NUMERIC_EXP)	Returns the numeric_exp sign. Returns-1 if numeric_exp is less than 0. If numeric_exp equals zero, 0 is returned. If numeric_exp is greater than 0, 1 is returned.
SIN(FLOAT_EXP)	Returns the sinusoidal value of the float_exp , where float_exp is the angle in radians.
TAN(FLOAT_EXP)	Returns the tangent of the float_exp , where float_exp is the angle in radians.
TRUNCATE(Numeric_exp, Integer_exp)	Returns the numeric_exptruncated to the integer_exp bit to the right of the decimal point. If integer_exp is negative, numeric_exp will be truncated to the left of the decimal point | Integer_exp| -bit

Numeric FunctionsCAST function

The cast function converts the value to the specified data type. The syntax is as follows:

CAST(exp as data_type)

The exp parameter can be a column name, the result of another scalar function, or a text. data_type can be any of the following keywords, which can be specified in uppercase or lowercase: CHAR, VARCHAR, INTEGER, SMALLINT, REAL, DOUBLE, DATE, Time, DATETIME, NUMERIC or DECIMAL.

For more information about the cast function, see CAST and CONVERT.

Full list of functions supported by Arcgis GDB file geodatabases, Shapefiles, coverages, and other file-based data sources