New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Having option to neo4i timezone config #1127
Comments
Currently the Neo4j DB doesn't have native support for times, dates, or timezones. I thought I had heard that they were hoping to do this in 3.0, but I'm not sure. So for now we should discuss this in terms of what Neo4j.rb can do with properties as they exist in Neo4j. In SQL (at least in some SQL databases) there is a concept of columns being either "datetime with timezone" or "datetime without timezone". With a timezone means that it stores both the stamp and the timezone that it is for. Without a timezone means that it stores everything in UTC or perhaps as a UNIX timestamp. In All of that was said to make sure that we're on the same page. AFAIK Neo4j.rb conforms to that, but are you finding behavior that doesn't work like that? Or is there something else that you would rather that it do? If so could you provide code examples? Thanks for the feedback! |
@cheerfulstoic Neo4j rb doesn't conforms to application.rb settings. |
I'm not sure I understand the issue. Could you fill out your example with a bit more info, especially about what is the correct expected behavior and what is the wrong behavior? Also, it would be really useful if you could pin down the first version between 6.1.1 and 6.1.7 caused the issue. Thanks! |
I'm seeing this with v7.0.5
Currently I have to convert to the timezone manually:
|
@gadikotamohan I would like to leave this open so that we can look into it / prioritize it later. If you don't want to receive notifications I believe that you can unsubscribe in the sidebar on the right. |
https://github.com/neo4jrb/neo4j/blob/12428d057150e35e65983a999593bd0de6e42666/lib/neo4j/shared/type_converters.rb#l166-#l172
I would suggest to have a neo4j's timezone to honor application.rb's default timezone or have seperate config..
Eg: I have timezone's config to 'Asia/Kolkata' and I expected the timestamp saved in to db is of 'Asia/Kolkata' but internally the datetime/time/date object is converted into utc and its timestamp is saved.
This isn't a issue, a feature request for neo4j.
The text was updated successfully, but these errors were encountered: