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

Incorrect result using TIME() to parse a string into time #2630

Closed
Aiee opened this issue Jul 19, 2021 · 0 comments · Fixed by #3179
Closed

Incorrect result using TIME() to parse a string into time #2630

Aiee opened this issue Jul 19, 2021 · 0 comments · Fixed by #3179
Assignees
Labels
type/enhancement Type: make the code neat or more efficient
Milestone

Comments

@Aiee
Copy link
Contributor

Aiee commented Jul 19, 2021

The outputs of TIME() and DATETIME() are filled with 0 in microseconds.

(root@nebula) [(none)]> return time("11:07:59.899023")
+-------------------------+
| time("11:07:59.899023") |
+-------------------------+
| 11:07:59.000000         |
+-------------------------+
Got 1 rows (time spent 757/1136 us)
(root@nebula) [(none)]> RETURN DATETIME("2021-07-19T11:01:03.123")
+-------------------------------------+
| datetime("2021-07-19T11:01:03.123") |
+-------------------------------------+
| 2021-07-19T11:01:03.000000          |
+-------------------------------------+
Got 1 rows (time spent 633/977 us)

Expected behavior
Screen Shot 2021-07-19 at 11 15 04 AM

@Shylock-Hg Shylock-Hg self-assigned this Jul 19, 2021
@CPWstatic CPWstatic transferred this issue from vesoft-inc/nebula-graph Aug 27, 2021
@CPWstatic CPWstatic added the type/bug Type: something is unexpected label Aug 28, 2021
@CPWstatic CPWstatic added this to the v2.6.0 milestone Aug 30, 2021
@Sophie-Xie Sophie-Xie added type/enhancement Type: make the code neat or more efficient and removed type/bug Type: something is unexpected labels Sep 28, 2021
@Sophie-Xie Sophie-Xie modified the milestones: v2.6.0, v3.0.0 Sep 28, 2021
@Sophie-Xie Sophie-Xie moved this to Coding in Nebula Graph v3.0.0 Oct 28, 2021
@Shylock-Hg Shylock-Hg moved this from Coding to Reviewing in Nebula Graph v3.0.0 Oct 28, 2021
Repository owner moved this from Reviewing to Done in Nebula Graph v3.0.0 Dec 13, 2021
yixinglu pushed a commit to yixinglu/nebula that referenced this issue Sep 14, 2023
…oper forms. (vesoft-inc#2630)

Co-authored-by: Cheng Xuntao <7731943+xtcyclist@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement Type: make the code neat or more efficient
Projects
No open projects
Status: Done
Development

Successfully merging a pull request may close this issue.

4 participants