cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Issue with timezone and daylight saving

shai
Node Link

I have a written a neo4j kernel plugin in java to perform a specific data load we need into the DB.
The nodes we create are time zone cognizant. Within our code we set the load time of the node using

LocalDateTime.now()

Up until the end of march it was running without issues. At the end of march clock was moved to DST. Now the latter piece of code returns the time but without the +1 hour DST so it is actually one hour behind.

Neo4j version 3.5.1
Neo4j is running on centOS 7.
TimeZone is set correctly and the OS returns the correct time in both TZ and DST.
in neo4j.conf we have the following:
dbms.logs.timezone=SYSTEM
dbms.jvm.additional=-Duser.timezone="Asia/Jerusalem"
db.temporal.timezone=Asia/Jerusalem

when running

with localDateTime() as now return now

I get the correct time with +1 DST.
Neo4j logs and my plugin code both don't get the correct time and are 1 hour behind.
If i check jshell on the neo4j machine and see what time is returned from LocalDateTime.now() I get the correct time. So it does not seem to be a java issue but it seems that neo4j core somehow disregards the DST in the timezone settings or even changes that setting.

I'll appreciate any help or clarification on this issue that may help me resolve this.
Tnx

1 REPLY 1

shai
Node Link

OK. After some investigating I found what is causing this problem.
The configuration line:
dbms.jvm.additional=-Duser.timezone="Asia/Jerusalem"

Once i removed it everything seems to be in order.
Hope this helps others

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online