Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Dates stored as local when server is in a time zone other than UTC when in couchbase #1

Open
jgomer2001 opened this issue Apr 20, 2021 · 0 comments
Open

Dates stored as local when server is in a time zone other than UTC when in couchbase #1

jgomer2001 opened this issue Apr 20, 2021 · 0 comments
Assignees
@jgomer2001

Comments

@jgomer2001
Copy link
Contributor

It is necessary to store dates like oxCreationTimestamp and updatedAt in ISO format with time zone UTC

Class org.gluu.persist.couchbase.impl.CouchbaseEntryManager uses Java SimpleDateFormat with format yyyy-MM-dd'T'HH:mm:ss.SSS (see encodeTime method) and this is correct as long as server timezone is UTC. When this is not the case, the date will be stored as a local date which is shifted.

In SCIM we use oxCreationTimestamp and updatedAt to build query filters and it is assumed that datetimes have no offset, ie. expressed in UTC
@jgomer2001 jgomer2001 self-assigned this Apr 20, 2021
jgomer2001 referenced this issue in GluuFederation/oxCore Apr 20, 2021
@jgomer2001
fix: issue #216
9a65cfe
@yurem yurem transferred this issue from GluuFederation/oxCore May 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jgomer2001 jgomer2001

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jgomer2001