Table of All Functions

The following table lists the current functions available in SciDB expressions. The third column indicates whether the function is available in the Community Edition or the Enterprise Edition, and which library contains that function. Where functions have individual pages, click the link to access those pages. For additional info on other functions, run: list('functions').

Function Name	Description	Edition, Library
%	Remainder.	CE, scidb
*	Multiplication.	CE, scidb
+	Addition.	CE, scidb
-	Subtraction or additive inverse.	CE, scidb
/	Division.	CE, scidb
<	Less than.	CE, scidb
<=	Less than or equal to.	CE, scidb
<>	Not equal.	CE, scidb
=	Equal.	CE, scidb
>	Greater than.	CE, scidb
>=	Greater than or equal to.	CE, scidb
abs	Absolute value.	CE, scidb
acos	Inverse (arc) cosine in radians.	CE, scidb
allzeros	Return a zero-values timestamp.	EE, timeseries
and	Infix logical AND.	CE, scidb
append_offset	Appends a GMT offset in seconds to a datetime attribute, yielding a datetimetz value.	CE, scidb
apply_offset	Converts a GMT datetime to local datetime by subtracting the offset timezone value, and stores the result as datetimetz including the offset timezone value.	CE, scidb
asin	Inverse (arc) sine in radians.	CE, scidb
atan	Inverse (arc) tangent in radians.	CE, scidb
binomcdf	Binomial cummulative distribution function.	EE, linear algebra
ceil	Round to next larger whole integer.	CE, scidb
chi2cdf	Chi-squared cumulative distribution function.	EE, linear algebra
cos	Cosine, input in radians.	CE, scidb
current_date	Current date value.	EE, timeseries
current_time	Current time value.	EE, timeseries
current_timestamp	Current timestamp value.	EE, timeseries
date_dt	Day of a date value.	EE, timeseries
date_fm	Datatype conversion.	EE, timeseries
day_of_week	Returns an integer alue representing the day of the week: 0 (Sunday) through 6 (Saturday).	CE, scidb
day_ts	Day of a timestamp value.	EE, timeseries
days_i	Days of an interval value.	EE, timeseries
exp	Exponential function.	CE, scidb
extract_dt	Extract a field you supply from a date value.	EE, timeseries
extract_i	Extract a field you supply from an interval value.	EE, timeseries
extract_tm	Extract a field you supply from a time value.	EE, timeseries
extract_ts	Extract a field you supply from a timestamp value.	EE, timeseries
first_index	The initial dimension value of the supplied dimension. This function takes two arguments: array name as a string, and optionally, dimension name as a string.	CE, scidb
floor	Round to the next-lowest integer.	CE, scidb
format_dt	Apply a format string to a date value.	EE, timeseries
format_i	Apply a format sting to an interval value.	EE, timeseries
format_tm	Apply a format string to a time value.	EE, timeseries
format_ts	Apply a format string to a timestamp value.	EE, timeseries
gcd_hf	Great circle distance, Haversine formula.	CE, linear algebra
gcd_slc	Great circle distance, spherical law of cosines.	CE, linear algebra
gcd_vif	Great circle distance, Vincenty formula.	CE, linear algebra
geomcdf	Geometric cumulative distribution function.	CE, linear algebra
get_offset	Returns the timezone offset, in seconds.	CE, scidb
high	Returns the maximum dimension value where the cell is is non-empty. This function takes two arguments: array name as a string, and optionally, dimension name as a string.	CE, scidb
hour_i	Hour of an interval value.	EE, timeseries
hour_of_day	Extracts the hour from a datetime attribute.	CE, scidb
hour_tm	Hour of a time value.	EE, timeseries
hour_ts	Hour of a timestamp value.	EE, timeseries
hygecdf	Hypergeometric cumulative distribution function	EE, linear algebra
hygepmf	Hypergeometric probability mass function.	EE, linear algebra
hygequant	Hypergeometric quantile function.	EE, linear algebra
ibinomcdf	Inverse binomial cumulative distribution function.	CE, linear algebra
ichi2cdf	Inverse chi-squared cumulative distribution function.	CE, linear algebra
igeomcdf	Inverse geometric cumulative distribution function.	CE, linear algebra
ihygecdf	Inverse hypergeometric cumulative distribution function.	CE, linear algebra
iif	Inline if: iif(expression, value_if_true, value_otherwise).	CE, scidb
inegbinomcdf	Inverse negative binomial cumulative distribution function.	CE, linear algebra
inormcdf	Inverse normal cumulative distribution function.	CE, linear algebra
instanceid	Returns the instance ID (int64) of the SciDB instance on which it is run. SciDB arrays are spread across some or all of the instances in the SciDB cluster. Thus, you can use the instanceid function to determine where the chunks of an array are stored.	CE, scidb
interval	Datatype conversion.	EE, timeseries
is_nan	Is NaN (not a number).	CE, scidb
is_null	Is NULL.	CE, scidb
itcdf	Inverse student's t-distribution cumulative distribution function.	CE, linear algebra
last_index	The final dimension value of the supplied dimension. This function takes two arguments: array name as a string, and optionally, dimension name as a string.	CE, scidb
length	Returns the size of the supplied dimension. This function takes two arguments: array name as a string, and optionally, dimension name as a string.	CE, scidb
localtime	The local time.	EE, timeseries
localtimestamp	The timestamp, based on the local timezone.	EE, timeseries
log	Natural logarithm.	CE, scidb
log10	Base-10 logarithm.	CE, scidb
low	Returns the minimum dimension value where the cell is is non-empty. This function takes two arguments: array name as a string, and optionally, dimension name as a string.	CE, scidb
make_dt	Returns a date value, assembled from individual values for year, month, and day.	EE, timeseries
make_i	Returns an interval value, assembled from days, hours, minutes, seconds, and microseconds. OR Returns an interval value, assembled from an integer and a unit: the unit can be 'sec', 'min', 'hour', or 'day'. OR Returns an interval value, assembled from hours, minutes, seconds, and microseconds.	EE, timeseries
make_tm	Returns a time value, assembled from individual values for hour, minutes, second, and microsecond.	EE, timeseries
make_ts	Returns a timestamp value, assembled from individual values for year, month, day, hour, minute, second, and microsecond. OR Returns a timestamp value, assembled from a date value and a time value.	EE, timeseries
max	Does not do what the name suggests. To find the maximum of two values, use iif(a > b, a, b) . With two bool arguments, it returns their logical OR. Use the infix or function instead. With two string arguments, it returns the string that is higher in the ASCII collating sequence.	CE, scidb
min	Does not do what the name suggests. To find the minimum of two values, use iif(a < b, a, b) . With two bool arguments, it returns their logical AND. Use the infix and function instead. With two string arguments, it returns the string that is lower in the ASCII collating sequence.	CE, scidb
min_i	Minutes of an interval value.	EE, timeseries
min_tm	Minutes of a time value.	EE, timeseries
min_ts	Minute of a timestamp value.	EE, timeseries
missing	Converts an int32 value into a NULL value with that missing reason code. Valid values must be in the range 0 ≤ x < 128.	CE, scidb
missing_reason	Returns the missing reason code for a value, or -1 if the value is not missing.	CE, scidb
month_dt	Month of a date value.	EE, timeseries
month_ts	Month of a timestamp value.	EE, timeseries
msec_i	Milliseconds of an interval value.	EE, timeseries
msec_tm	Milliseconds of a time value.	EE, timeseries
msec_ts	Milliseconds of a timestamp value.	EE, timeseries
negbinomcdf	Negative binomial cumulative distribution function.	CE, linear algebra
normcdf	Normal cumulative distribution function.	CE, linear algebra
not	Boolean NOT.	CE, scidb
now	Returns the current date and time.	CE, scidb
now_dt	The current date.	EE, timeseries
now_tm	The current time.	EE, timeseries
now_ts	The current timestamp.	EE, timeseries
or	Infix logical OR.	CE, scidb
pow	Raise to a power: pow(base,exponent).	CE, scidb
random	Generate random positive integer. The maximum value is the maximum signed 32-bit integer: 2,147,483,647	CE, scidb
regex	Regular expression matching function regex(string_attribute, pattern). Uses the regular expression language from the Boost library. Returns true on a match.	CE, scidb
scan_dt	Interpret input string according to the format and convert to a datetime: scan_dt(format, input).	EE, timeseries
scan_i	Interpret input string according to the format and convert to a time interval: scan_i(format, input).	EE, timeseries
scan_tm	Interpret input string according to the format and convert to a struct tm time value: scan_tm(format, input).	EE, timeseries
scan_ts	Interpret input string according to the format and convert to a timestamp value: scan_ts(format, input).	EE, timeseries
sec_i	Seconds of an interval value.	EE, timeseries
sec_tm	Seconds of a time value.	EE, timeseries
sec_ts	Seconds of a timestamp value.	EE, timeseries
sin	Sine function.	CE, scidb
sizeof	Returns size of its argument data object in bytes, as a uint64.	CE, scidb
sqrt	Square root.	CE, scidb
strftime	Returns the formatted date and time, based on the formatting options that you pass to the function. The format string is as for the Linux strftime function.	CE, scidb
strftime_dt	Returns the formatted date, based on the formatting options that you pass to the function. The format string is as for the Linux strftime function.	EE, timeseries
strftime_tm	Returns the formatted time, based on the formatting options that you pass to the function. The format string is as for the Linux strftime function.	EE, timeseries
strftime_ts	Returns the formatted timestamp, based on the formatting options that you pass to the function. The format string is as for the Linux strftime function.	EE, timeseries
strip_offset	Returns the datetime value, after stripping the timezone offset from a datetimetz argument.	CE, scidb
strlen	Returns the string length as an int32.	CE, scidb
substr	Returns a substring of a string you supply: substr(the_string, start, end).	CE, scidb
tan	Tangent.	CE, scidb
tcdf	Student's t cumulative distribution function.	CE, linear algebra
time	Datatype conversion.	EE, timeseries
time_fm	Datatype conversion.	EE, timeseries
timestamp	Datatype conversion.	CE, timeseries
timestamp_fm	Datatype conversion.	EE, timeseries
today_dt	The current date.	EE, timeseries
today_ts	The current timestamp.	EE, timeseries
togmt	Converts a datetimetz to a datetime, adding in the timezone offset to return the GMT date and time that corresponds to the input.	CE, scidb
tomorrow_dt	Tomorrow's date.	EE, timeseries
tomorrow_ts	Tomorrow's timestamp.	EE, timeseries
tznow	Returns the current date and time as a datetimetz.	CE, scidb
usec_i	Microseconds of an interval value.	EE, timeseries
usec_tm	Microseconds of a time value.	EE, timeseries
usec_ts	Microsecond of a timestamp value.	EE, timeseries
wday_dt	Weekday of a date value.	EE, timeseries
wday_ts	Weekday of a timestamp value.	EE, timeseries
yday_dt	Julian date of a date value.	EE, timeseries
yday_ts	Julian date of a timestamp value.	EE, timeseries
year_dt	Year of a date value.	EE, timeseries
year_ts	Year of a timestamp value.	EE, timeseries
yesterday_dt	Yesterday's date.	EE, timeseries
yesterday_ts	Yesterday's timestamp.	EE, timeseries

Browser not supported