Neo4j: Temporal functions – Instant Types cheat sheet

date() function

Getting the current Date

date([ {timezone} ])

Creating a calendar (Year-Month-Day) Date

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

Creating a week (Year-Week-Day) Date

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

Creating a quarter (Year-Quarter-Day) Date

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

Creating an ordinal (Year-Day) Date

date({year [, ordinalDay]})

Creating a Date from a string

date(temporalValue)

Creating a Date using other temporal values as components

date({date [, year, month, day, week, dayOfWeek, quarter, dayOfQuarter, ordinalDay]})

datetime() function

Getting the current DateTime

datetime([ {timezone} ])

Creating a calendar (Year-Month-Day) DateTime

datetime({year [, month, day, hour, minute, second, millisecond, microsecond, nanosecond, timezone]})

Creating a week (Year-Week-Day) DateTime

datetime({year [, week, dayOfWeek, hour, minute, second, millisecond, microsecond, nanosecond, timezone]})

Creating an ordinal (Year-Day) DateTime

datetime({year [, ordinalDay, hour, minute, second, millisecond, microsecond, nanosecond, timezone]})

localdatetime() function

Getting the current LocalDateTime

localdatetime([ {timezone} ])

time() function

Getting the current Time

time([ {timezone} ])

Creating a Time

time({hour [, minute, second, millisecond, microsecond, nanosecond, timezone]})

Creating a Time from a string

time(temporalValue)

Creating a Time using other temporal values as components

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

Truncating a Time

time.truncate(unit [, temporalInstantValue [, mapOfComponents ] ])

Leave a Reply

Your email address will not be published. Required fields are marked *