Blog


  • In the latest version of cypher(3.4) it provides user allowing for the creation and updating of each type of values like — Date, Time, LocalTime, DateTime, LocalDateTime and Duration.
    Each of the functions of neo4j has the same capabilities as the type depicts and they are

    Date — made up of Date (conceptually year, month and day).
    Time — made by using a Time property viz (hour, minute, second, and sub-seconds).The subsecond is further divided into 3 parts namely millisecond, microsecond and nanosecond.

    DateTime — as the name suggests it is made by combining above(date+time) .NOTE: if the type is created and the type from which the time component is being selected both contain timezone (and a timezone is not explicitly specified) the timezone is also selected.

    LocalDateTime - it is also made by date and time but doesn't contain the timezone.
    Duration -- It can be used to construct a Duration object from a map of its components in the same way as the temporal instant types.
    eg: duration([ {years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, nanoseconds} ])
    All the neo4j's temporal instant types with or without timezone allow timezone to be specified for function and also supports the current instant in a specified time zone.

    example:

     If we want the current datetime from cypher return datetime() as currentDateWithTime;                     output    "2018-10-31T16:00:40.011000000Z"
     If we want the only current date from cypher return date() as todaysDate;                                 output    "2018-10-31"
     If we want the only current time from cypher return time() as currentTime;                                output    "16:01:47.270000000Z"  
     If we want the only current datetime in milliseconds from cypher return timestamp() as currentInstant;    output    1541001734159
     To construct date with time from miliseconds return dateTime({epochmillis:timestamp()})                   output    "2018-10-31T16:02:43.958000000Z"
     To construct date with time from miliseconds return date(dateTime({epochmillis:timestamp()}))             output    "2018-10-31"
    

Tags: neo4j