-
Notifications
You must be signed in to change notification settings - Fork 735
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
Feature: Date Functions to support week as a unit #16402
Comments
Databend currently supports adding and subtracting various time units such as years, months, days, hours, minutes, and seconds, but it appears that the To add support for the
For detailed guidance on writing and registering new functions, you can refer to the following guides: This process will ensure that the |
Maybe you can try: root@localhost:8000/default> SELECT DATE_ADD('day', 7, TODAY());
SELECT
DATE_ADD('day', 7, TODAY())
-[ RECORD 1 ]-----------------------------------
DATE_ADD(DAY, 7, today()): 2024-09-12
And I think it's a good first issue. |
Yes @TCeason This would be a good addition for DATE functionality to ADD ON. Thanks! It is good to have week as an unit. multiplication of 7 would be required. |
Please assign me 😊 |
Summary
Not able to perform Date operations with unit week. Can it be added as a additional support for
week
.QUERY:
SELECT DATE_ADD('week', 1, TODAY());
The text was updated successfully, but these errors were encountered: