Glossary of keywords

Clauses
Operators
Functions
Expressions
Cypher^® query options

Clauses

Clause Category Description

Clause	Category	Description
CALL […YIELD]	Reading/Writing	Invoke a procedure deployed in the database.
CREATE	Writing	Create nodes and relationships.
CREATE CONSTRAINT ON (n:Label) ASSERT exists(n.property)	Schema	Create a constraint ensuring that all nodes with a particular label have a certain property.
CREATE CONSTRAINT ON (n:Label) ASSERT (n.prop1, …, n.propN) IS NODE KEY	Schema	Create a constraint ensuring all nodes with a particular label have all the specified properties and that the combination of property values is unique; i.e. ensures existence and uniqueness.
CREATE CONSTRAINT ON ()-[r:REL_TYPE]-() ASSERT exists(r.property)	Schema	Create a constraint ensuring that all relationship with a particular type have a certain property.
CREATE CONSTRAINT ON (n:Label) ASSERT n.property IS UNIQUE	Schema	Create a constraint ensuring the uniqueness of the combination of node label and property value for a particular property key across all nodes.
CREATE INDEX ON :Label(property)	Schema	Create an index on all nodes with a particular label and a single property; i.e. create a single-property index.
CREATE INDEX ON :Label(prop1, …, propN)	Schema	Create an index on all nodes with a particular label and multiple properties; i.e. create a composite index.
DELETE	Writing	Delete nodes, relationships or paths. Any node to be deleted must also have all associated relationships explicitly deleted.
DETACH DELETE	Writing	Delete a node or set of nodes. All associated relationships will automatically be deleted.
DROP CONSTRAINT ON (n:Label) ASSERT exists(n.property)	Schema	Drop a constraint ensuring that all nodes with a particular label have a certain property.
DROP CONSTRAINT ON ()-[r:REL_TYPE]-() ASSERT exists(r.property)	Schema	Drop a constraint ensuring that all relationship with a particular type have a certain property.
DROP CONSTRAINT ON (n:Label) ASSERT n.property IS UNIQUE	Schema	Drop a constraint ensuring the uniqueness of the combination of node label and property value for a particular property key across all nodes.
DROP CONSTRAINT ON (n:Label) ASSERT (n.prop1, …, n.propN) IS NODE KEY	Schema	Drop a constraint ensuring all nodes with a particular label have all the specified properties and that the combination of property values is unique.
DROP INDEX ON :Label(property)	Schema	Drop an index from all nodes with a particular label and a single property; i.e. drop a single-property index.
DROP INDEX ON :Label(prop1, …, propN)	Schema	Drop an index from all nodes with a particular label and multiple properties; i.e. drop a composite index.
FOREACH	Writing	Update data within a list, whether components of a path, or the result of aggregation.
LIMIT	Reading sub-clause	A sub-clause used to constrain the number of rows in the output.
LOAD CSV	Importing data	Use when importing data from CSV files.
MATCH	Reading	Specify the patterns to search for in the database.
MERGE	Reading/Writing	Ensures that a pattern exists in the graph. Either the pattern already exists, or it needs to be created.
ON CREATE	Reading/Writing	Used in conjunction with `MERGE`, specifying the actions to take if the pattern needs to be created.
ON MATCH	Reading/Writing	Used in conjunction with `MERGE`, specifying the actions to take if the pattern already exists.
OPTIONAL MATCH	Reading	Specify the patterns to search for in the database while using `nulls` for missing parts of the pattern.
ORDER BY [ASC[ENDING] \| DESC[ENDING]]	Reading sub-clause	A sub-clause following `RETURN` or `WITH`, specifying that the output should be sorted in either ascending (the default) or descending order.
REMOVE	Writing	Remove properties and labels from nodes and relationships.
RETURN … [AS]	Projecting	Defines what to include in the query result set.
SET	Writing	Update labels on nodes and properties on nodes and relationships.
SKIP	Reading/Writing	A sub-clause defining from which row to start including the rows in the output.
UNION	Set operations	Combines the result of multiple queries. Duplicates are removed.
UNION ALL	Set operations	Combines the result of multiple queries. Duplicates are retained.
UNWIND … [AS]	Projecting	Expands a list into a sequence of rows.
USING INDEX variable:Label(property)	Hint	Index hints are used to specify which index, if any, the planner should use as a starting point.
USING INDEX SEEK variable:Label(property)	Hint	Index seek hint instructs the planner to use an index seek for this clause.
USING JOIN ON variable	Hint	Join hints are used to enforce a join operation at specified points.
USING PERIODIC COMMIT	Hint	This query hint may be used to prevent an out-of-memory error from occurring when importing large amounts of data using `LOAD CSV`.
USING SCAN variable:Label	Hint	Scan hints are used to force the planner to do a label scan (followed by a filtering operation) instead of using an index.
WITH … [AS]	Projecting	Allows query parts to be chained together, piping the results from one to be used as starting points or criteria in the next.
WHERE	Reading sub-clause	A sub-clause used to add constraints to the patterns in a `MATCH` or `OPTIONAL MATCH` clause, or to filter the results of a `WITH` clause.

CALL […YIELD]

Reading/Writing

Invoke a procedure deployed in the database.

CREATE

Writing

Create nodes and relationships.

CREATE CONSTRAINT ON (n:Label) ASSERT exists(n.property)

Schema

Create a constraint ensuring that all nodes with a particular label have a certain property.

CREATE CONSTRAINT ON (n:Label) ASSERT (n.prop1, …, n.propN) IS NODE KEY

Schema

Create a constraint ensuring all nodes with a particular label have all the specified properties and that the combination of property values is unique; i.e. ensures existence and uniqueness.

CREATE CONSTRAINT ON ()-[r:REL_TYPE]-() ASSERT exists(r.property)

Schema

Create a constraint ensuring that all relationship with a particular type have a certain property.

CREATE CONSTRAINT ON (n:Label) ASSERT n.property IS UNIQUE

Schema

Create a constraint ensuring the uniqueness of the combination of node label and property value for a particular property key across all nodes.

CREATE INDEX ON :Label(property)

Schema

Create an index on all nodes with a particular label and a single property; i.e. create a single-property index.

CREATE INDEX ON :Label(prop1, …, propN)

Schema

Create an index on all nodes with a particular label and multiple properties; i.e. create a composite index.

DELETE

Writing

Delete nodes, relationships or paths. Any node to be deleted must also have all associated relationships explicitly deleted.

DETACH DELETE

Writing

Delete a node or set of nodes. All associated relationships will automatically be deleted.

DROP CONSTRAINT ON (n:Label) ASSERT exists(n.property)

Schema

Drop a constraint ensuring that all nodes with a particular label have a certain property.

DROP CONSTRAINT ON ()-[r:REL_TYPE]-() ASSERT exists(r.property)

Schema

Drop a constraint ensuring that all relationship with a particular type have a certain property.

DROP CONSTRAINT ON (n:Label) ASSERT n.property IS UNIQUE

Schema

Drop a constraint ensuring the uniqueness of the combination of node label and property value for a particular property key across all nodes.

DROP CONSTRAINT ON (n:Label) ASSERT (n.prop1, …, n.propN) IS NODE KEY

Schema

Drop a constraint ensuring all nodes with a particular label have all the specified properties and that the combination of property values is unique.

DROP INDEX ON :Label(property)

Schema

Drop an index from all nodes with a particular label and a single property; i.e. drop a single-property index.

DROP INDEX ON :Label(prop1, …, propN)

Schema

Drop an index from all nodes with a particular label and multiple properties; i.e. drop a composite index.

FOREACH

Writing

Update data within a list, whether components of a path, or the result of aggregation.

LIMIT

Reading sub-clause

A sub-clause used to constrain the number of rows in the output.

LOAD CSV

Importing data

Use when importing data from CSV files.

MATCH

Reading

Specify the patterns to search for in the database.

MERGE

Reading/Writing

Ensures that a pattern exists in the graph. Either the pattern already exists, or it needs to be created.

ON CREATE

Reading/Writing

Used in conjunction with MERGE, specifying the actions to take if the pattern needs to be created.

ON MATCH

Reading/Writing

Used in conjunction with MERGE, specifying the actions to take if the pattern already exists.

OPTIONAL MATCH

Reading

Specify the patterns to search for in the database while using nulls for missing parts of the pattern.

ORDER BY [ASC[ENDING] | DESC[ENDING]]

Reading sub-clause

A sub-clause following RETURN or WITH, specifying that the output should be sorted in either ascending (the default) or descending order.

REMOVE

Writing

Remove properties and labels from nodes and relationships.

RETURN … [AS]

Projecting

Defines what to include in the query result set.

SET

Writing

Update labels on nodes and properties on nodes and relationships.

SKIP

Reading/Writing

A sub-clause defining from which row to start including the rows in the output.

UNION

Set operations

Combines the result of multiple queries. Duplicates are removed.

UNION ALL

Set operations

Combines the result of multiple queries. Duplicates are retained.

UNWIND … [AS]

Projecting

Expands a list into a sequence of rows.

USING INDEX variable:Label(property)

Hint

Index hints are used to specify which index, if any, the planner should use as a starting point.

USING INDEX SEEK variable:Label(property)

Hint

Index seek hint instructs the planner to use an index seek for this clause.

USING JOIN ON variable

Hint

Join hints are used to enforce a join operation at specified points.

USING PERIODIC COMMIT

Hint

This query hint may be used to prevent an out-of-memory error from occurring when importing large amounts of data using LOAD CSV.

USING SCAN variable:Label

Hint

Scan hints are used to force the planner to do a label scan (followed by a filtering operation) instead of using an index.

WITH … [AS]

Projecting

Allows query parts to be chained together, piping the results from one to be used as starting points or criteria in the next.

WHERE

Reading sub-clause

A sub-clause used to add constraints to the patterns in a MATCH or OPTIONAL MATCH clause, or to filter the results of a WITH clause.

Operators

Operator Category Description

Operator	Category	Description
%	Mathematical	Modulo division
*	Mathematical	Multiplication
*	Temporal	Multiplying a duration with a number
+	Mathematical	Addition
+	String	Concatenation
+=	Property	Property mutation
+	List	Concatenation
+	Temporal	Adding two durations, or a duration and a temporal instant
-	Mathematical	Subtraction or unary minus
-	Temporal	Subtracting a duration from a temporal instant or from another duration
.	Map	Static value access by key
.	Property	Static property access
/	Mathematical	Division
/	Temporal	Dividing a duration by a number
<	Comparison	Less than
<=	Comparison	Less than or equal to
<>	Comparison	Inequality
=	Comparison	Equality
=	Property	Property replacement
=~	String	Regular expression match
>	Comparison	Greater than
>=	Comparison	Greater than or equal to
AND	Boolean	Conjunction
CONTAINS	String comparison	Case-sensitive inclusion search
DISTINCT	Aggregation	Duplicate removal
ENDS WITH	String comparison	Case-sensitive suffix search
IN	List	List element existence check
IS NOT NULL	Comparison	Non-`null` check
IS NULL	Comparison	`null` check
NOT	Boolean	Negation
OR	Boolean	Disjunction
STARTS WITH	String comparison	Case-sensitive prefix search
XOR	Boolean	Exclusive disjunction
[]	Map	Subscript (dynamic value access by key)
[]	Property	Subscript (dynamic property access)
[]	List	Subscript (accessing element(s) in a list)
^	Mathematical	Exponentiation

Mathematical

Modulo division

Mathematical

Multiplication

Temporal

Multiplying a duration with a number

Mathematical

Addition

String

Concatenation

Property

Property mutation

List

Concatenation

Temporal

Adding two durations, or a duration and a temporal instant

Mathematical

Subtraction or unary minus

Temporal

Subtracting a duration from a temporal instant or from another duration

Map

Static value access by key

Property

Static property access

Mathematical

Division

Temporal

Dividing a duration by a number

Comparison

Less than

Comparison

Less than or equal to

Comparison

Inequality

Comparison

Equality

Property

Property replacement

String

Regular expression match

Comparison

Greater than

Comparison

Greater than or equal to

AND

Boolean

Conjunction

CONTAINS

String comparison

Case-sensitive inclusion search

DISTINCT

Aggregation

Duplicate removal

ENDS WITH

String comparison

Case-sensitive suffix search

List

List element existence check

IS NOT NULL

Comparison

Non-null check

IS NULL

Comparison

null check

NOT

Boolean

Negation

Boolean

Disjunction

STARTS WITH

String comparison

Case-sensitive prefix search

XOR

Boolean

Exclusive disjunction

[]

Map

Subscript (dynamic value access by key)

[]

Property

Subscript (dynamic property access)

[]

List

Subscript (accessing element(s) in a list)

Mathematical

Exponentiation

Functions

Function Category Description

Function	Category	Description
abs()	Numeric	Returns the absolute value of a number.
acos()	Trigonometric	Returns the arccosine of a number in radians.
all()	Predicate	Tests whether the predicate holds for all elements in a list.
any()	Predicate	Tests whether the predicate holds for at least one element in a list.
asin()	Trigonometric	Returns the arcsine of a number in radians.
atan()	Trigonometric	Returns the arctangent of a number in radians.
atan2()	Trigonometric	Returns the arctangent2 of a set of coordinates in radians.
avg()	Aggregating	Returns the average of a set of values.
ceil()	Numeric	Returns the smallest floating point number that is greater than or equal to a number and equal to a mathematical integer.
coalesce()	Scalar	Returns the first non-`null` value in a list of expressions.
collect()	Aggregating	Returns a list containing the values returned by an expression.
cos()	Trigonometric	Returns the cosine of a number.
cot()	Trigonometric	Returns the cotangent of a number.
count()	Aggregating	Returns the number of values or rows.
date()	Temporal	Returns the current Date.
date({year [, month, day]})	Temporal	Returns a calendar (Year-Month-Day) Date.
date({year [, week, dayOfWeek]})	Temporal	Returns a week (Year-Week-Day) Date.
date({year [, quarter, dayOfQuarter]})	Temporal	Returns a quarter (Year-Quarter-Day) Date.
date({year [, ordinalDay]})	Temporal	Returns an ordinal (Year-Day) Date.
date(string)	Temporal	Returns a Date by parsing a string.
date({map})	Temporal	Returns a Date from a map of another temporal value’s components.
date.realtime()	Temporal	Returns the current Date using the `realtime` clock.
date.statement()	Temporal	Returns the current Date using the `statement` clock.
date.transaction()	Temporal	Returns the current Date using the `transaction` clock.
date.truncate()	Temporal	Returns a Date obtained by truncating a value at a specific component boundary. Truncation summary.
datetime()	Temporal	Returns the current DateTime.
datetime({year [, month, day, …]})	Temporal	Returns a calendar (Year-Month-Day) DateTime.
datetime({year [, week, dayOfWeek, …]})	Temporal	Returns a week (Year-Week-Day) DateTime.
datetime({year [, quarter, dayOfQuarter, …]})	Temporal	Returns a quarter (Year-Quarter-Day) DateTime.
datetime({year [, ordinalDay, …]})	Temporal	Returns an ordinal (Year-Day) DateTime.
datetime(string)	Temporal	Returns a DateTime by parsing a string.
datetime({map})	Temporal	Returns a DateTime from a map of another temporal value’s components.
datetime({epochSeconds})	Temporal	Returns a DateTime from a timestamp.
datetime.realtime()	Temporal	Returns the current DateTime using the `realtime` clock.
datetime.statement()	Temporal	Returns the current DateTime using the `statement` clock.
datetime.transaction()	Temporal	Returns the current DateTime using the `transaction` clock.
datetime.truncate()	Temporal	Returns a DateTime obtained by truncating a value at a specific component boundary. Truncation summary.
degrees()	Trigonometric	Converts radians to degrees.
distance()	Spatial	Returns a floating point number representing the geodesic distance between any two points in the same CRS.
duration({map})	Temporal	Returns a Duration from a map of its components.
duration(string)	Temporal	Returns a Duration by parsing a string.
duration.between()	Temporal	Returns a Duration equal to the difference between two given instants.
duration.inDays()	Temporal	Returns a Duration equal to the difference in whole days or weeks between two given instants.
duration.inMonths()	Temporal	Returns a Duration equal to the difference in whole months, quarters or years between two given instants.
duration.inSeconds()	Temporal	Returns a Duration equal to the difference in seconds and fractions of seconds, or minutes or hours, between two given instants.
e()	Logarithmic	Returns the base of the natural logarithm, `e`.
endNode()	Scalar	Returns the end node of a relationship.
exists()	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.
exp()	Logarithmic	Returns `e^n`, where `e` is the base of the natural logarithm, and `n` is the value of the argument expression.
extract()	List	Returns a list `l_result` containing the values resulting from an expression which has been applied to each element in a list `list`.
filter()	List	Returns a list `l_result` containing all the elements from a list `list` that comply with a predicate.
floor()	Numeric	Returns the largest floating point number that is less than or equal to a number and equal to a mathematical integer.
haversin()	Trigonometric	Returns half the versine of a number.
head()	Scalar	Returns the first element in a list.
id()	Scalar	Returns the id of a relationship or node.
keys()	List	Returns a list containing the string representations for all the property names of a node, relationship, or map.
labels()	List	Returns a list containing the string representations for all the labels of a node.
last()	Scalar	Returns the last element in a list.
left()	String	Returns a string containing the specified number of leftmost characters of the original string.
length()	Scalar	Returns the length of a path.
localdatetime()	Temporal	Returns the current LocalDateTime.
localdatetime({year [, month, day, …]})	Temporal	Returns a calendar (Year-Month-Day) LocalDateTime.
localdatetime({year [, week, dayOfWeek, …]})	Temporal	Returns a week (Year-Week-Day) LocalDateTime.
localdatetime({year [, quarter, dayOfQuarter, …]})	Temporal	Returns a quarter (Year-Quarter-Day) DateTime.
localdatetime({year [, ordinalDay, …]})	Temporal	Returns an ordinal (Year-Day) LocalDateTime.
localdatetime(string)	Temporal	Returns a LocalDateTime by parsing a string.
localdatetime({map})	Temporal	Returns a LocalDateTime from a map of another temporal value’s components.
localdatetime.realtime()	Temporal	Returns the current LocalDateTime using the `realtime` clock.
localdatetime.statement()	Temporal	Returns the current LocalDateTime using the `statement` clock.
localdatetime.transaction()	Temporal	Returns the current LocalDateTime using the `transaction` clock.
localdatetime.truncate()	Temporal	Returns a LocalDateTime obtained by truncating a value at a specific component boundary. Truncation summary.
localtime()	Temporal	Returns the current LocalTime.
localtime({hour [, minute, second, …]})	Temporal	Returns a LocalTime with the specified component values.
localtime(string)	Temporal	Returns a LocalTime by parsing a string.
localtime({time [, hour, …]})	Temporal	Returns a LocalTime from a map of another temporal value’s components.
localtime.realtime()	Temporal	Returns the current LocalTime using the `realtime` clock.
localtime.statement()	Temporal	Returns the current LocalTime using the `statement` clock.
localtime.transaction()	Temporal	Returns the current LocalTime using the `transaction` clock.
localtime.truncate()	Temporal	Returns a LocalTime obtained by truncating a value at a specific component boundary. Truncation summary.
log()	Logarithmic	Returns the natural logarithm of a number.
log10()	Logarithmic	Returns the common logarithm (base 10) of a number.
lTrim()	String	Returns the original string with leading whitespace removed.
max()	Aggregating	Returns the maximum value in a set of values.
min()	Aggregating	Returns the minimum value in a set of values.
nodes()	List	Returns a list containing all the nodes in a path.
none()	Predicate	Returns true if the predicate holds for no element in a list.
percentileCont()	Aggregating	Returns the percentile of the given value over a group using linear interpolation.
percentileDisc()	Aggregating	Returns the nearest value to the given percentile over a group using a rounding method.
pi()	Trigonometric	Returns the mathematical constant pi.
point() - Cartesian 2D	Spatial	Returns a 2D point object, given two coordinate values in the Cartesian coordinate system.
point() - Cartesian 3D	Spatial	Returns a 3D point object, given three coordinate values in the Cartesian coordinate system.
point() - WGS 84 2D	Spatial	Returns a 2D point object, given two coordinate values in the WGS 84 coordinate system.
point() - WGS 84 3D	Spatial	Returns a 3D point object, given three coordinate values in the WGS 84 coordinate system.
properties()	Scalar	Returns a map containing all the properties of a node or relationship.
radians()	Trigonometric	Converts degrees to radians.
rand()	Numeric	Returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e. `[0, 1)`.
randomUUID()	Scalar	Returns a string value corresponding to a randomly-generated UUID.
range()	List	Returns a list comprising all integer values within a specified range.
reduce()	List	Runs an expression against individual elements of a list, storing the result of the expression in an accumulator.
relationships()	List	Returns a list containing all the relationships in a path.
replace()	String	Returns a string in which all occurrences of a specified string in the original string have been replaced by another (specified) string.
reverse()	List	Returns a list in which the order of all elements in the original list have been reversed.
reverse()	String	Returns a string in which the order of all characters in the original string have been reversed.
right()	String	Returns a string containing the specified number of rightmost characters of the original string.
round()	Numeric	Returns the value of a number rounded to the nearest integer.
rTrim()	String	Returns the original string with trailing whitespace removed.
sign()	Numeric	Returns the signum of a number: `0` if the number is `0`, `-1` for any negative number, and `1` for any positive number.
sin()	Trigonometric	Returns the sine of a number.
single()	Predicate	Returns true if the predicate holds for exactly one of the elements in a list.
size()	Scalar	Returns the number of items in a list.
size() applied to pattern expression	Scalar	Returns the number of paths matching the pattern expression.
size() applied to string	Scalar	Returns the number of Unicode characters in a string.
split()	String	Returns a list of strings resulting from the splitting of the original string around matches of the given delimiter.
sqrt()	Logarithmic	Returns the square root of a number.
startNode()	Scalar	Returns the start node of a relationship.
stDev()	Aggregating	Returns the standard deviation for the given value over a group for a sample of a population.
stDevP()	Aggregating	Returns the standard deviation for the given value over a group for an entire population.
substring()	String	Returns a substring of the original string, beginning with a 0-based index start and length.
sum()	Aggregating	Returns the sum of a set of numeric values.
tail()	List	Returns all but the first element in a list.
tan()	Trigonometric	Returns the tangent of a number.
time()	Temporal	Returns the current Time.
time({hour [, minute, …]})	Temporal	Returns a Time with the specified component values.
time(string)	Temporal	Returns a Time by parsing a string.
time({time [, hour, …, timezone]})	Temporal	Returns a Time from a map of another temporal value’s components.
time.realtime()	Temporal	Returns the current Time using the `realtime` clock.
time.statement()	Temporal	Returns the current Time using the `statement` clock.
time.transaction()	Temporal	Returns the current Time using the `transaction` clock.
time.truncate()	Temporal	Returns a Time obtained by truncating a value at a specific component boundary. Truncation summary.
timestamp()	Scalar	Returns the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC.
toBoolean()	Scalar	Converts a string value to a boolean value.
toFloat()	Scalar	Converts an integer or string value to a floating point number.
toInteger()	Scalar	Converts a floating point or string value to an integer value.
toLower()	String	Returns the original string in lowercase.
toString()	String	Converts an integer, float, boolean or temporal (i.e. Date, Time, LocalTime, DateTime, LocalDateTime or Duration) value to a string.
toUpper()	String	Returns the original string in uppercase.
trim()	String	Returns the original string with leading and trailing whitespace removed.
type()	Scalar	Returns the string representation of the relationship type.

abs()

Numeric

Returns the absolute value of a number.

acos()

Trigonometric

Returns the arccosine of a number in radians.

all()

Predicate

Tests whether the predicate holds for all elements in a list.

any()

Predicate

Tests whether the predicate holds for at least one element in a list.

asin()

Trigonometric

Returns the arcsine of a number in radians.

atan()

Trigonometric

Returns the arctangent of a number in radians.

atan2()

Trigonometric

Returns the arctangent2 of a set of coordinates in radians.

avg()

Aggregating

Returns the average of a set of values.

ceil()

Numeric

Returns the smallest floating point number that is greater than or equal to a number and equal to a mathematical integer.

coalesce()

Scalar

Returns the first non-null value in a list of expressions.

collect()

Aggregating

Returns a list containing the values returned by an expression.

cos()

Trigonometric

Returns the cosine of a number.

cot()

Trigonometric

Returns the cotangent of a number.

count()

Aggregating

Returns the number of values or rows.

date()

Temporal

Returns the current Date.

date({year [, month, day]})

Temporal

Returns a calendar (Year-Month-Day) Date.

date({year [, week, dayOfWeek]})

Temporal

Returns a week (Year-Week-Day) Date.

date({year [, quarter, dayOfQuarter]})

Temporal

Returns a quarter (Year-Quarter-Day) Date.

date({year [, ordinalDay]})

Temporal

Returns an ordinal (Year-Day) Date.

date(string)

Temporal

Returns a Date by parsing a string.

date({map})

Temporal

Returns a Date from a map of another temporal value’s components.

date.realtime()

Temporal

Returns the current Date using the realtime clock.

date.statement()

Temporal

Returns the current Date using the statement clock.

date.transaction()

Temporal

Returns the current Date using the transaction clock.

date.truncate()

Temporal

Returns a Date obtained by truncating a value at a specific component boundary. Truncation summary.

datetime()

Temporal

Returns the current DateTime.

datetime({year [, month, day, …]})

Temporal

Returns a calendar (Year-Month-Day) DateTime.

datetime({year [, week, dayOfWeek, …]})

Temporal

Returns a week (Year-Week-Day) DateTime.

datetime({year [, quarter, dayOfQuarter, …]})

Temporal

Returns a quarter (Year-Quarter-Day) DateTime.

datetime({year [, ordinalDay, …]})

Temporal

Returns an ordinal (Year-Day) DateTime.

datetime(string)

Temporal

Returns a DateTime by parsing a string.

datetime({map})

Temporal

Returns a DateTime from a map of another temporal value’s components.

datetime({epochSeconds})

Temporal

Returns a DateTime from a timestamp.

datetime.realtime()

Temporal

Returns the current DateTime using the realtime clock.

datetime.statement()

Temporal

Returns the current DateTime using the statement clock.

datetime.transaction()

Temporal

Returns the current DateTime using the transaction clock.

datetime.truncate()

Temporal

Returns a DateTime obtained by truncating a value at a specific component boundary. Truncation summary.

degrees()

Trigonometric

Converts radians to degrees.

distance()

Spatial

Returns a floating point number representing the geodesic distance between any two points in the same CRS.

duration({map})

Temporal

Returns a Duration from a map of its components.

duration(string)

Temporal

Returns a Duration by parsing a string.

duration.between()

Temporal

Returns a Duration equal to the difference between two given instants.

duration.inDays()

Temporal

Returns a Duration equal to the difference in whole days or weeks between two given instants.

duration.inMonths()

Temporal

Returns a Duration equal to the difference in whole months, quarters or years between two given instants.

duration.inSeconds()

Temporal

Returns a Duration equal to the difference in seconds and fractions of seconds, or minutes or hours, between two given instants.

e()

Logarithmic

Returns the base of the natural logarithm, e.

endNode()

Scalar

Returns the end node of a relationship.

exists()

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.

exp()

Logarithmic

Returns e^n, where e is the base of the natural logarithm, and n is the value of the argument expression.

extract()

List

Returns a list l_result containing the values resulting from an expression which has been applied to each element in a list list.

filter()

List

Returns a list l_result containing all the elements from a list list that comply with a predicate.

floor()

Numeric

Returns the largest floating point number that is less than or equal to a number and equal to a mathematical integer.

haversin()

Trigonometric

Returns half the versine of a number.

head()

Scalar

Returns the first element in a list.

id()

Scalar

Returns the id of a relationship or node.

keys()

List

Returns a list containing the string representations for all the property names of a node, relationship, or map.

labels()

List

Returns a list containing the string representations for all the labels of a node.

last()

Scalar

Returns the last element in a list.

left()

String

Returns a string containing the specified number of leftmost characters of the original string.

length()

Scalar

Returns the length of a path.

localdatetime()

Temporal

Returns the current LocalDateTime.

localdatetime({year [, month, day, …]})

Temporal

Returns a calendar (Year-Month-Day) LocalDateTime.

localdatetime({year [, week, dayOfWeek, …]})

Temporal

Returns a week (Year-Week-Day) LocalDateTime.

localdatetime({year [, quarter, dayOfQuarter, …]})

Temporal

Returns a quarter (Year-Quarter-Day) DateTime.

localdatetime({year [, ordinalDay, …]})

Temporal

Returns an ordinal (Year-Day) LocalDateTime.

localdatetime(string)

Temporal

Returns a LocalDateTime by parsing a string.

localdatetime({map})

Temporal

Returns a LocalDateTime from a map of another temporal value’s components.

localdatetime.realtime()

Temporal

Returns the current LocalDateTime using the realtime clock.

localdatetime.statement()

Temporal

Returns the current LocalDateTime using the statement clock.

localdatetime.transaction()

Temporal

Returns the current LocalDateTime using the transaction clock.

localdatetime.truncate()

Temporal

Returns a LocalDateTime obtained by truncating a value at a specific component boundary. Truncation summary.

localtime()

Temporal

Returns the current LocalTime.

localtime({hour [, minute, second, …]})

Temporal

Returns a LocalTime with the specified component values.

localtime(string)

Temporal

Returns a LocalTime by parsing a string.

localtime({time [, hour, …]})

Temporal

Returns a LocalTime from a map of another temporal value’s components.

localtime.realtime()

Temporal

Returns the current LocalTime using the realtime clock.

localtime.statement()

Temporal

Returns the current LocalTime using the statement clock.

localtime.transaction()

Temporal

Returns the current LocalTime using the transaction clock.

localtime.truncate()

Temporal

Returns a LocalTime obtained by truncating a value at a specific component boundary. Truncation summary.

log()

Logarithmic

Returns the natural logarithm of a number.

log10()

Logarithmic

Returns the common logarithm (base 10) of a number.

lTrim()

String

Returns the original string with leading whitespace removed.

max()

Aggregating

Returns the maximum value in a set of values.

min()

Aggregating

Returns the minimum value in a set of values.

nodes()

List

Returns a list containing all the nodes in a path.

none()

Predicate

Returns true if the predicate holds for no element in a list.

percentileCont()

Aggregating

Returns the percentile of the given value over a group using linear interpolation.

percentileDisc()

Aggregating

Returns the nearest value to the given percentile over a group using a rounding method.

pi()

Trigonometric

Returns the mathematical constant pi.

point() - Cartesian 2D

Spatial

Returns a 2D point object, given two coordinate values in the Cartesian coordinate system.

point() - Cartesian 3D

Spatial

Returns a 3D point object, given three coordinate values in the Cartesian coordinate system.

point() - WGS 84 2D

Spatial

Returns a 2D point object, given two coordinate values in the WGS 84 coordinate system.

point() - WGS 84 3D

Spatial

Returns a 3D point object, given three coordinate values in the WGS 84 coordinate system.

properties()

Scalar

Returns a map containing all the properties of a node or relationship.

radians()

Trigonometric

Converts degrees to radians.

rand()

Numeric

Returns a random floating point number in the range from 0 (inclusive) to 1 (exclusive); i.e. [0, 1).

randomUUID()

Scalar

Returns a string value corresponding to a randomly-generated UUID.

range()

List

Returns a list comprising all integer values within a specified range.

reduce()

List

Runs an expression against individual elements of a list, storing the result of the expression in an accumulator.

relationships()

List

Returns a list containing all the relationships in a path.

replace()

String

Returns a string in which all occurrences of a specified string in the original string have been replaced by another (specified) string.

reverse()

List

Returns a list in which the order of all elements in the original list have been reversed.

reverse()

String

Returns a string in which the order of all characters in the original string have been reversed.

right()

String

Returns a string containing the specified number of rightmost characters of the original string.

round()

Numeric

Returns the value of a number rounded to the nearest integer.

rTrim()

String

Returns the original string with trailing whitespace removed.

sign()

Numeric

Returns the signum of a number: 0 if the number is 0, -1 for any negative number, and 1 for any positive number.

sin()

Trigonometric

Returns the sine of a number.

single()

Predicate

Returns true if the predicate holds for exactly one of the elements in a list.

size()

Scalar

Returns the number of items in a list.

size() applied to pattern expression

Scalar

Returns the number of paths matching the pattern expression.

size() applied to string

Scalar

Returns the number of Unicode characters in a string.

split()

String

Returns a list of strings resulting from the splitting of the original string around matches of the given delimiter.

sqrt()

Logarithmic

Returns the square root of a number.

startNode()

Scalar

Returns the start node of a relationship.

stDev()

Aggregating

Returns the standard deviation for the given value over a group for a sample of a population.

stDevP()

Aggregating

Returns the standard deviation for the given value over a group for an entire population.

substring()

String

Returns a substring of the original string, beginning with a 0-based index start and length.

sum()

Aggregating

Returns the sum of a set of numeric values.

tail()

List

Returns all but the first element in a list.

tan()

Trigonometric

Returns the tangent of a number.

time()

Temporal

Returns the current Time.

time({hour [, minute, …]})

Temporal

Returns a Time with the specified component values.

time(string)

Temporal

Returns a Time by parsing a string.

time({time [, hour, …, timezone]})

Temporal

Returns a Time from a map of another temporal value’s components.

time.realtime()

Temporal

Returns the current Time using the realtime clock.

time.statement()

Temporal

Returns the current Time using the statement clock.

time.transaction()

Temporal

Returns the current Time using the transaction clock.

time.truncate()

Temporal

Returns a Time obtained by truncating a value at a specific component boundary. Truncation summary.

timestamp()

Scalar

Returns the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC.

toBoolean()

Scalar

Converts a string value to a boolean value.

toFloat()

Scalar

Converts an integer or string value to a floating point number.

toInteger()

Scalar

Converts a floating point or string value to an integer value.

toLower()

String

Returns the original string in lowercase.

toString()

String

Converts an integer, float, boolean or temporal (i.e. Date, Time, LocalTime, DateTime, LocalDateTime or Duration) value to a string.

toUpper()

String

Returns the original string in uppercase.

trim()

String

Returns the original string with leading and trailing whitespace removed.

type()

Scalar

Returns the string representation of the relationship type.

Expressions

Name	Description
CASE Expression	A generic conditional expression, similar to if/else statements available in other languages.

Name

Description

CASE Expression

A generic conditional expression, similar to if/else statements available in other languages.

Cypher query options

Name Type Description

Name	Type	Description
CYPHER $version query	Version	This will force `'query'` to use Neo4j Cypher `$version`. The default is `3.3`.
CYPHER planner=rule query	Planner	This will force `'query'` to use the rule planner. As the rule planner was removed in 3.2, doing this will cause `'query'` to fall back to using Cypher 3.1.
CYPHER planner=cost query	Planner	Neo4j 3.5 uses the cost planner for all queries.
CYPHER runtime=interpreted query	Runtime	This will force the query planner to use the interpreted runtime. This is the only option in Neo4j Community Edition.
CYPHER runtime=slotted query	Runtime	This will cause the query planner to use the slotted runtime. This is only available in Neo4j Enterprise Edition.
CYPHER runtime=compiled query	Runtime	This will cause the query planner to use the compiled runtime if it supports `'query'`. This is only available in Neo4j Enterprise Edition.

CYPHER $version query

Version

This will force 'query' to use Neo4j Cypher $version. The default is 3.3.

CYPHER planner=rule query

Planner

This will force 'query' to use the rule planner. As the rule planner was removed in 3.2, doing this will cause 'query' to fall back to using Cypher 3.1.

CYPHER planner=cost query

Planner

Neo4j 3.5 uses the cost planner for all queries.

CYPHER runtime=interpreted query

Runtime

This will force the query planner to use the interpreted runtime. This is the only option in Neo4j Community Edition.

CYPHER runtime=slotted query

Runtime

This will cause the query planner to use the slotted runtime. This is only available in Neo4j Enterprise Edition.

CYPHER runtime=compiled query

Runtime

This will cause the query planner to use the compiled runtime if it supports 'query'. This is only available in Neo4j Enterprise Edition.