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

nGQL: add new datetime functions like datediff and dateadd #3101

Closed
Sophie-Xie opened this issue Oct 15, 2021 · 0 comments
Closed

nGQL: add new datetime functions like datediff and dateadd #3101

Sophie-Xie opened this issue Oct 15, 2021 · 0 comments
Assignees
Labels
type/feature req Type: feature request
Milestone

Comments

@Sophie-Xie
Copy link
Contributor

Sophie-Xie commented Oct 15, 2021

Describe the background of the requirement
It's quite a common requirement from customers to calculate the datetime type, e.g, and today it's only possible to do so via timestamp operations, not convenient at all;

Describe the detail of the requirement
Propose to add some new datetime functions, e.g.:

datediff(date1, date2) to return the days between date1 and date2;
dateadd(date1, n) to return a new date value of date1+ n days, n can be a negative number.
etc.

Describe the scenarios of the requirement
This can be helpful in various scenarios when users need to calculate against datetime data type.

Describe the values of the requirement
General: nGQL usability
Values for customer: simplify writing nGQL when datetime calculations are involved.
Importance of the business project: it's common request.

from jingchun

@Sophie-Xie Sophie-Xie added the type/feature req Type: feature request label Oct 15, 2021
@Sophie-Xie Sophie-Xie added this to the v3.0.0 milestone Oct 15, 2021
@Sophie-Xie Sophie-Xie changed the title nGQL: add new datetime functions like datediff and dateadd #38 nGQL: add new datetime functions like datediff and dateadd Oct 15, 2021
@Sophie-Xie Sophie-Xie moved this to Backlog in Nebula Graph v3.0.0 Oct 28, 2021
@Shylock-Hg Shylock-Hg moved this from Backlog to Designing in Nebula Graph v3.0.0 Oct 28, 2021
@Sophie-Xie Sophie-Xie moved this from Designing to Coding in Nebula Graph v3.0.0 Nov 4, 2021
@Shylock-Hg Shylock-Hg mentioned this issue Nov 22, 2021
7 tasks
@Sophie-Xie Sophie-Xie moved this from Coding to Reviewing in Nebula Graph v3.0.0 Dec 9, 2021
Repository owner moved this from Reviewing to Done in Nebula Graph v3.0.0 Dec 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature req Type: feature request
Projects
No open projects
Status: Done
Development

No branches or pull requests

2 participants