apoc.date.toYears

Function

apoc.date.toYears(value ANY, format STRING) - converts the given timestamp or the given date into a FLOAT representing years.

Signature

apoc.date.toYears(value :: ANY, format = yyyy-MM-dd HH:mm:ss :: STRING) :: FLOAT

Name	Type	Default
value	ANY	null
format	STRING	yyyy-MM-dd HH:mm:ss

Name

Type

Default

value

ANY

null

format

STRING

yyyy-MM-dd HH:mm:ss

The following converts a datetime in milliseconds to floating point years:

WITH datetime("2020-11-05").epochMillis AS datetime
RETURN apoc.date.toYears(datetime) AS years;

Table 1. Results
years
50.87945205479452

The following converts a date to floating point years:

RETURN apoc.date.toYears("2020-11-02", "YYYY-MM-dd") AS years;

Table 2. Results
years
2020.027397260274