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

cli: time values are printed as timestamps #29044

Closed
rytaft opened this issue Aug 24, 2018 · 1 comment · Fixed by #62310
Closed

cli: time values are printed as timestamps #29044

rytaft opened this issue Aug 24, 2018 · 1 comment · Fixed by #62310
Labels
A-cli-client CLI commands that pertain to using SQL features C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. S-3-ux-surprise Issue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.

Comments

@rytaft
Copy link
Collaborator

rytaft commented Aug 24, 2018

While doing QA for #28158, I noticed that columns with a TIME datatype are printed with a timestamp format. For example, the time "4:05" is printed as "0000-01-01 04:05:00+00:00". This seems undesirable....
@rytaft rytaft mentioned this issue Aug 24, 2018
Closed
@knz
Copy link
Contributor

knz commented Oct 15, 2018

Note that this a problem in lib/pq which assigns all datetime-like SQL types to Go's Time type.

@knz knz added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. S-3-ux-surprise Issue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption. and removed O-qa labels Oct 15, 2018
@knz knz added A-cli-client CLI commands that pertain to using SQL features and removed A-cli labels Mar 20, 2021
@knz knz mentioned this issue Mar 20, 2021
Merged
@craig craig bot closed this as completed in ec08282 Mar 22, 2021
@ericharmeling ericharmeling mentioned this issue May 27, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-cli-client CLI commands that pertain to using SQL features C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. S-3-ux-surprise Issue leaves users wondering whether CRDB is behaving properly. Likely to hurt reputation/adoption.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

cli/sql: properly format different times and floats knz/cockroach
2 participants
@knz @rytaft