Skip to content

Query the time difference function from the view, and the value becomes negative #23592

@0xqq

Description

@0xqq

Search before asking

  • I had searched in the issues and found no similar issues.

Version

select minutes_diff('2023-01-16 10:05:04', '2023-01-15 18:05:04') dt

create view v2 as
select minutes_diff('2023-01-16 10:05:04', '2023-01-15 18:05:04') dt

select dt from v2

What's Wrong?

the value becomes negative

What You Expected?

the value correct

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions