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

SHOW SESSIONS displays timestamp in timezone set by the user #107649

Closed
thtruo opened this issue Jul 26, 2023 · 0 comments · Fixed by #107988
Closed

SHOW SESSIONS displays timestamp in timezone set by the user #107649

thtruo opened this issue Jul 26, 2023 · 0 comments · Fixed by #107988
Assignees
@rafiss
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@thtruo
Copy link
Contributor

thtruo commented Jul 26, 2023 •
edited by exalate-issue-sync bot
Loading

Is your feature request related to a problem? Please describe.
See #107644
This request is specific to making SHOW SESSIONS display timestamp values that obey the timezone set by the user.

Describe the solution you'd like
When a user sets their timezone to a non-UTC value for their session in the database, SHOW SESSIONS should display timestamp fields in that selected timezone.

cc @dikshant

Jira issue: CRDB-30145

Epic CRDB-24406
@thtruo thtruo added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Jul 26, 2023
@thtruo thtruo mentioned this issue Jul 26, 2023
Closed
5 tasks
@rafiss rafiss mentioned this issue Aug 1, 2023
Merged
@craig craig bot closed this as completed in 76b5348 Aug 3, 2023
@rafiss rafiss mentioned this issue Aug 3, 2023
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rafiss rafiss

Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql: respect timezone for SHOW QUERIES/SESSIONS rafiss/cockroach
2 participants
@rafiss @thtruo