Cypher builtin functions

NameSignatureDescription
absabs(NUMBER?) :: NUMBER?

absolute value of a number

acosacos(NUMBER?) :: FLOAT?

arcosine (in radians) of a number

asinasin(NUMBER?) :: FLOAT?

arcsine (in radians) of a number

atanatan(NUMBER?) :: FLOAT?

arctangent (in radians) of a number

atan2atan2(NUMBER?, NUMBER?) :: FLOAT?

arctangent (in radians) of the quotient of its arguments

ceilceil(NUMBER?) :: FLOAT?

smallest integer greater than or equal to the input

coalescecoalesce(ANY?, ..) :: ANY?

returns the first non-null value in a list of expressions

coscos(NUMBER?) :: FLOAT?

cosine of a number of radians

cotcot(NUMBER?) :: FLOAT?

cotangent of a number of radians

degreesdegrees(NUMBER?) :: FLOAT?

convert radians to degrees

ee() :: FLOAT?

mathematical constant e

expexp(NUMBER?) :: FLOAT?

return the mathematical constant e raised to the power of the input

floorfloor(NUMBER?) :: FLOAT?

largest integer less than or equal to the input

haversinhaversin(NUMBER?) :: FLOAT?

half the versine of a number

headhead(LIST? OF ANY?) :: ANY?

extract the first element of a list

idid(NODE?) :: ANY?

extract the ID of a node

keyskeys(ANY?) :: LIST? OF STRING?

extract the keys from a map, node, or relationship

lTrimlTrim(STRING?) :: STRING?

original string with leading whitespace removed

labelslabels(ANY?) :: LIST? OF STRING?

extract the labels of a node or relationship

lastlast(LIST? OF ANY?) :: ANY?

extract the last element of a list

leftleft(STRING?, INTEGER?) :: STRING?

string containing the specified number of leftmost characters of the original string

lengthlength(PATH?) :: INTEGER?

length of a path (ie. the number of relationships in it)

loglog(NUMBER?) :: FLOAT?

natural logarithm of a number

log10log10(NUMBER?) :: FLOAT?

common logarithm (base 10) of a number

nodesnodes(PATH?) :: LIST? OF NODE?

extract a list of nodes in a path

pipi() :: FLOAT?

mathematical constant π

propertiesproperties(ANY?) :: MAP?

extract the properties from a map, node, or relationship

rTrimrTrim(STRING?) :: STRING?

original string with trailing whitespace removed

radiansradians(NUMBER?) :: FLOAT?

convert degrees to radians

randrand() :: FLOAT?

random float between 0 (inclusive) and 1 (exclusive)

rangerange(start :: INTEGER, end :: INTEGER, step :: INTEGER?) :: LIST? OF INTEGER?

construct a list of integers representing a range

relationshipsrelationships(PATH?) :: LIST? OF RELATIONSHIP?

extract a list of relationships in a path

replacereplace(original :: STRING?, target :: STRING?, replacement :: STRING?) :: STRING?

replace every occurrence of a target string

reversereverse(ANY?) :: ANY?

reverse a string or list

rightright(STRING?, INTEGER?) :: STRING?

string containing the specified number of rightmost characters of the original string

roundround(input :: NUMBER?, precision :: INTEGER?, mode :: STRING?) :: FLOAT?

nearest number to the input

signsign(NUMBER?) :: INTEGER?

signum of a number

sinsin(NUMBER?) :: FLOAT?

sine of a number of radians

sizesize(ANY?) :: INTEGER?

number of elements in a list or characters in a string

splitsplit(input :: STRING?, delimiter :: STRING?) :: LIST? OF STRING?

split a string on every instance of a delimiter

sqrtsqrt(NUMBER?) :: FLOAT?

square root of a number

substringsubstring(original :: STRING?, start :: INTEGER? [, end :: INTEGER? ]) :: STRING?

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

tailtail(LIST? OF ANY?) :: LIST? OF ANY?

return the list without its first element

tantan(NUMBER?) :: FLOAT?

tangent of a number of radians

timestamptimestamp() :: INTEGER?

number of milliseconds elapsed since midnight, January 1, 1970 UTC

toBooleantoBoolean(STRING?) :: BOOLEAN?

convert a string into a boolean

toFloattoFloat(ANY?) :: FLOAT?

convert a string or integer into a float

toIntegertoInteger(ANY?) :: INTEGER?

convert a string or float into an integer

toLowertoLower(STRING?) :: STRING?

convert a string to lowercase

toStringtoString(ANY?) :: STRING?

convert a value to a string

toUppertoUpper(STRING?) :: STRING?

convert a string to uppercase

trimtrim(STRING?) :: STRING?

removing leading and trailing whitespace from a string

typetype(RELATIONSHIP?) :: STRING?

return the name of a relationship