date_trunc('year', '2025-04-28 12:12:12');这样用为什么会报错，文档不是写的两种方式都行吗？ #2339

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.

Sign up for GitHub

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

Jump to bottom

Open

CaoChunfang opened this issue Apr 28, 2025 · 1 comment

CaoChunfang commented Apr 28, 2025

Path:/zh-CN/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/date-trunc

如题，date_trunc('year', '2025-04-28 12:12:12')使用date_trunc函数会报错，但是文档却说两种方式都行？
SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = date_trunc function second param only support argument is year|quarter|month|week|day|hour|minute|second

The text was updated successfully, but these errors were encountered:

Contributor

KassieZ commented May 20, 2025

感谢反馈，将与技术支持同学确认。如果有关技术问题，后续也可以前往 Apache Doris 中文技术论坛

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment