Skip to content

Built-in date and time functions

Nebula Graph supports the following built-in date and time functions:

Function Description
int now() Return the current date and time of the system time zone.
date date() Return the current UTC date based on the current system.
time time() Return the current UTC calendar time of the current time zone.
datetime datetime() Return the current UTC datetime based on the current time.

The date(), time(), and datetime() functions accept three kind of parameters, namely empty, string, and map.

Examples

> RETURN now(), date(), time(), datetime();
+------------+------------+--------------+-------------------------+
| now()      | date()     | time()       | datetime()              |
+------------+------------+--------------+-------------------------+
| 1611907165 | 2021-01-29 | 07:59:22.000 | 2021-01-29T07:59:22.000 |
+------------+------------+--------------+-------------------------+

OpenCypher compatibility

  • Time in openCypher is measured in milliseconds.
  • Time in nGQL is measured in seconds. The milliseconds are displayed in 000.

Last update: March 29, 2021