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.

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

time zone inconsistency timers #75

Closed
martindsouza opened this issue Feb 19, 2015 · 1 comment
Closed

time zone inconsistency timers #75

martindsouza opened this issue Feb 19, 2015 · 1 comment
Assignees
Labels
Milestone

Comments

@martindsouza
Copy link
Member

From @tomvdduin on August 12, 2014 7:3

the type ts_array is a table of timestamp. But the procedures time_start and time_stop uses systimestamp; that has a time zone specified. I am at GMT+2, and regularly have something like this in the logger table:
START: test
STOP : test- 01:59:59.969

So the ts_array shold be defined by timestamp with time zone or you should use localtimestamp instead of systimestamp

Copied from original issue: tmuth#74

@martindsouza
Copy link
Member Author

We're looking at re-writing the timer methods and this is good information to take into consideration when designing them.

@martindsouza martindsouza removed their assignment May 1, 2015
martindsouza added a commit that referenced this issue May 30, 2015
@martindsouza martindsouza self-assigned this May 30, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant