包括数值函数,字符函数,时间函数,列表函数和聚合函数等。
Functions
Function | Category | Description |
---|---|---|
Numeric | Returns the absolute value of a number. | |
Trigonometric | Returns the arccosine of a number in radians. | |
Predicate | Tests whether the predicate holds for all elements in a list. | |
Predicate | Tests whether the predicate holds for at least one element in a list. | |
Trigonometric | Returns the arcsine of a number in radians. | |
Trigonometric | Returns the arctangent of a number in radians. | |
Trigonometric | Returns the arctangent2 of a set of coordinates in radians. | |
Aggregating | Returns the average of a set of values. | |
Numeric | Returns the smallest floating point number that is greater than or equal to a number and equal to a mathematical integer. | |
Scalar | Returns the first non- | |
Aggregating | Returns a list containing the values returned by an expression. | |
Trigonometric | Returns the cosine of a number. | |
Trigonometric | Returns the cotangent of a number. | |
Aggregating | Returns the number of values or rows. | |
Temporal | Returns the current Date. | |
Temporal | Returns a calendar (Year-Month-Day) Date. | |
Temporal | Returns a week (Year-Week-Day) Date. | |
Temporal | Returns a quarter (Year-Quarter-Day) Date. | |
Temporal | Returns an ordinal (Year-Day) Date. | |
Temporal | Returns a Date by parsing a string. | |
Temporal | Returns a Date from a map of another temporal value’s components. | |
Temporal | Returns the current Date using the | |
Temporal | Returns the current Date using the | |
Temporal | Returns the current Date using the | |
Temporal | Returns a Date obtained by truncating a value at a specific component boundary. Truncation summary. | |
Temporal | Returns the current DateTime. | |
Temporal | Returns a calendar (Year-Month-Day) DateTime. | |
Temporal | Returns a week (Year-Week-Day) DateTime. | |
Temporal | Returns a quarter (Year-Quarter-Day) DateTime. | |
Temporal | Returns an ordinal (Year-Day) DateTime. | |
Temporal | Returns a DateTime by parsing a string. | |
Temporal | Returns a DateTime from a map of another temporal value’s components. | |
Temporal | Returns a DateTime from a timestamp. | |
Temporal | Returns the current DateTime using the | |
Temporal | Returns the current DateTime using the | |
Temporal | Returns the current DateTime using the | |
Temporal | Returns a DateTime obtained by truncating a value at a specific component boundary. Truncation summary. | |
Trigonometric | Converts radians to degrees. | |
Temporal | Returns a Duration from a map of its components. | |
Temporal | Returns a Duration by parsing a string. | |
Temporal | Returns a Duration equal to the difference between two given instants. | |
Temporal | Returns a Duration equal to the difference in whole days or weeks between two given instants. | |
Temporal | Returns a Duration equal to the difference in whole months, quarters or years between two given instants. | |
Temporal | Returns a Duration equal to the difference in seconds and fractions of seconds, or minutes or hours, between two given instants. | |
Logarithmic | Returns the base of the natural logarithm, | |
Scalar | Returns the end node of a relationship. | |
Predicate | Returns true if a match for the pattern exists in the graph, or if the specified property exists in the node, relationship or map. | |
Logarithmic | Returns | |
Numeric | Returns the largest floating point number that is less than or equal to a number and equal to a mathematical integer. | |
Trigonometric | Returns half the versine of a number. | |
Scalar | Returns the first element in a list. | |
Scalar | Returns the id of a relationship or node. | |
Predicate | Returns true if the given list or map contains no elements or if the given string contains no characters. | |
List | Returns a list containing the string representations for all the property names of a node, relationship, or map. | |
List | Returns a list containing the string representations for all the labels of a node. | |
Scalar | Returns the last element in a list. | |
String | Returns a string containing the specified number of leftmost characters of the original string. | |
Scalar | Returns the length of a path. | |
Temporal | Returns the current LocalDateTime. | |
Temporal | Returns a calendar (Year-Month-Day) LocalDateTime. | |
Temporal | Returns a week (Year-Week-Day) LocalDateTime. | |
Temporal | Returns a quarter (Year-Quarter-Day) DateTime. | |
Temporal | Returns an ordinal (Year-Day) LocalDateTime. | |
Temporal | Returns a LocalDateTime by parsing a string. | |
Temporal | Returns a LocalDateTime from a map of another temporal value’s components. | |
Temporal | Returns the current LocalDateTime using the | |
Temporal | Returns the current LocalDateTime using the | |
Temporal | Returns the current LocalDateTime using the | |
Temporal | Returns a LocalDateTime obtained by truncating a value at a specific component boundary. Truncation summary. | |
Temporal | Returns the current LocalTime. | |
Temporal | Returns a LocalTime with the specified component values. | |
Temporal | Returns a LocalTime by parsing a string. | |
Temporal | Returns a LocalTime from a map of another temporal value’s components. | |
Temporal | Returns the current LocalTime using the | |
Temporal | Returns the current LocalTime using the | |
Temporal | Returns the current LocalTime using the | |
Temporal | Returns a LocalTime obtained by truncating a value at a specific component boundary. Truncation summary. | |
Logarithmic | Returns the natural logarithm of a number. | |
Logarithmic | Returns the common logarithm (base 10) of a number. | |
String | Returns the original string with leading whitespace removed. | |
Aggregating | Returns the maximum value in a set of values. | |
Aggregating | Returns the minimum value in a set of values. | |
List | Returns a list containing all the nodes in a path. | |
Predicate | Returns true if the predicate holds for no element in a list. | |
Aggregating | Returns the percentile of the given value over a group using linear interpolation. | |
Aggregating | Returns the nearest value to the given percentile over a group using a rounding method. | |
Trigonometric | Returns the mathematical constant pi. | |
Spatial | Returns a 2D point object, given two coordinate values in the Cartesian coordinate system. | |
Spatial | Returns a 3D point object, given three coordinate values in the Cartesian coordinate system. | |
Spatial | Returns a 2D point object, given two coordinate values in the WGS 84 coordinate system. | |
Spatial | Returns a 3D point object, given three coordinate values in the WGS 84 coordinate system. | |
Spatial | Returns true if the provided point is within the bounding box defined by the two provided points. | |
Spatial | Returns a floating point number representing the geodesic distance between any two points in the same CRS. | |
Scalar | Returns a map containing all the properties of a node or relationship. | |
Trigonometric | Converts degrees to radians. | |
Numeric | Returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e. | |
Scalar | Returns a string value corresponding to a randomly-generated UUID. | |
List | Returns a list comprising all integer values within a specified range. | |
List | Runs an expression against individual elements of a list, storing the result of the expression in an accumulator. | |
List | Returns a list containing all the relationships in a path. | |
String | Returns a string in which all occurrences of a specified string in the original string have been replaced by another (specified) string. | |
List | Returns a list in which the order of all elements in the original list have been reversed. | |
String | Returns a string in which the order of all characters in the original string have been reversed. | |
String | Returns a string containing the specified number of rightmost characters of the original string. | |
Numeric | Returns the value of the given number rounded to the nearest integer, with half-way values always rounded up. | |
Numeric | Returns the value of the given number rounded with the specified precision, with half-values always being rounded up. | |
Numeric | Returns the value of the given number rounded with the specified precision and the specified rounding mode. | |
String | Returns the original string with trailing whitespace removed. | |
Numeric | Returns the signum of a number: | |
Trigonometric | Returns the sine of a number. | |
Predicate | Returns true if the predicate holds for exactly one of the elements in a list. | |
Scalar | Returns the number of items in a list. | |
Scalar | Returns the number of paths matching the pattern expression. | |
Scalar | Returns the number of Unicode characters in a string. | |
String | Returns a list of strings resulting from the splitting of the original string around matches of the given delimiter. | |
Logarithmic | Returns the square root of a number. | |
Scalar | Returns the start node of a relationship. | |
Aggregating | Returns the standard deviation for the given value over a group for a sample of a population. | |
Aggregating | Returns the standard deviation for the given value over a group for an entire population. | |
String | Returns a substring of the original string, beginning with a 0-based index start and length. | |
Aggregating | Returns the sum of a set of numeric values. | |
List | Returns all but the first element in a list. | |
Trigonometric | Returns the tangent of a number. | |
Temporal | Returns the current Time. | |
Temporal | Returns a Time with the specified component values. | |
Temporal | Returns a Time by parsing a string. | |
Temporal | Returns a Time from a map of another temporal value’s components. | |
Temporal | Returns the current Time using the | |
Temporal | Returns the current Time using the | |
Temporal | Returns the current Time using the | |
Temporal | Returns a Time obtained by truncating a value at a specific component boundary. Truncation summary. | |
Scalar | Returns the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC. | |
Scalar | Converts a string value to a boolean value. | |
Scalar | Converts an integer or string value to a floating point number. | |
Scalar | Converts a floating point or string value to an integer value. | |
String | Returns the original string in lowercase. | |
String | Converts an integer, float, boolean or temporal (i.e. Date, Time, LocalTime, DateTime, LocalDateTime or Duration) value to a string. | |
String | Returns the original string in uppercase. | |
String | Returns the original string with leading and trailing whitespace removed. | |
Scalar | Returns the string representation of the relationship type. |