Skip to content

Error result in to_days function #1838

@HangyuanLiu

Description

@HangyuanLiu

TO_DAYS('1997-10-07'), TO_DAYS('97-10-07') should be same result in mysql

But the result return by Doris is error
MySQL [(none)]> SELECT TO_DAYS('1997-10-07'), TO_DAYS('97-10-07');
+-----------------------+-----------------------+
| to_days('1997-10-07') | to_days('0097-10-07') |
+-----------------------+-----------------------+
| 729669 | 35709 |
+-----------------------+-----------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    kind/fixCategorizes issue or PR as related to a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions