We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Summary
Databend lacks a DATE_DIFF function, though it supports direct arithmetic on dates and times (e.g., TO_DATE(NOW()) - 2 for two days ago). However, users may find this conversion difficult, see: https://docs.databend.com/sql/sql-functions/datetime-functions/date-diff
Proposal add a DATE_DIFF function:
DATE_DIFF
DATE_DIFF(<date_or_time_part>, <date_or_time_expr1>, <date_or_time_expr2>)
Similar to Snowflake's DATEDIFF function, this will simplify date and time arithmetic for users.
The text was updated successfully, but these errors were encountered:
I would like to have a try.
Sorry, something went wrong.
select to_date('2024-02-29') + - to_date('2025-02-28');
chagelo
No branches or pull requests
Summary
Databend lacks a DATE_DIFF function, though it supports direct arithmetic on dates and times (e.g., TO_DATE(NOW()) - 2 for two days ago). However, users may find this conversion difficult, see: https://docs.databend.com/sql/sql-functions/datetime-functions/date-diff
Proposal add a
DATE_DIFF
function:Similar to Snowflake's DATEDIFF function, this will simplify date and time arithmetic for users.
The text was updated successfully, but these errors were encountered: