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

Supports date_add and date_sub function #2593

Closed
killme2008 opened this issue Oct 12, 2023 · 0 comments · Fixed by #2881
Closed

Supports date_add and date_sub function #2593

killme2008 opened this issue Oct 12, 2023 · 0 comments · Fixed by #2881
Assignees
Labels
C-feature Category Features

Comments

@killme2008
Copy link
Contributor

What problem does the new feature solve?

DATE_ADD(date, INTERVAL value interval_type)

and

DATE_SUB(date, INTERVAL value interval_type)

For example:

SELECT DATE_ADD('2015-06-15', INTERVAL '5 YEAR') AS Result; 

SELECT DATE_SUB(now(), INTERVAL '5 YEAR') AS Result; 

What does the feature do?

As a TSDB, we must have more functions to support date or time types.

Implementation challenges

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category Features
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants