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

time change or time-zone change are not supported #46

Closed
marcingminski opened this issue Sep 18, 2018 · 0 comments
Closed

time change or time-zone change are not supported #46

marcingminski opened this issue Sep 18, 2018 · 0 comments
Assignees
@marcingminski
Labels
bug Something isn't working
Projects
DB 2.0
Milestone
TIme zone agnostic

Comments

@marcingminski
Copy link
Owner

upon changing clocks backwards (from summer to winter time) or changing time zone to behind current time zone, the data collection will fail due to the primary key violation as it will try to insert the same time again.
The fix is to introduce GETUTCDATEs on insert and TIMEOFFSET when selecting from tables
@marcingminski marcingminski added the bug Something isn't working label Sep 18, 2018
@marcingminski marcingminski added this to the Roadmap milestone Sep 18, 2018
@marcingminski marcingminski self-assigned this Sep 18, 2018
@marcingminski marcingminski added this to To do in v1 Roadmap via automation Sep 18, 2018
@marcingminski marcingminski removed this from To do in v1 Roadmap Mar 10, 2019
@marcingminski marcingminski added this to In progress in DB 2.0 Apr 25, 2019
@marcingminski marcingminski moved this from In progress to Done in DB 2.0 Apr 25, 2019
@marcingminski marcingminski modified the milestones: 1.x, TIme zone agnostic Apr 25, 2019
marcingminski added a commit that referenced this issue Apr 25, 2019
@marcingminski
fixes #46 UTC dates
c749fb4 
add on update cascade in preparation to migrate to utc dates

change getdate to getutcdate

add manual utcdate migration script
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@marcingminski marcingminski

Labels
bug Something isn't working
Projects
No open projects
DB 2.0
  
Done
Milestone
TIme zone agnostic
Development

No branches or pull requests
1 participant
@marcingminski