Skip to content
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

trino to_char function return wrong result #51920

Open
LZGH opened this issue Oct 15, 2024 · 0 comments
Open

trino to_char function return wrong result #51920

LZGH opened this issue Oct 15, 2024 · 0 comments
Labels
type/bug Something isn't working

Comments

@LZGH
Copy link

LZGH commented Oct 15, 2024

In starrocks, to_char is rewritten as jodatime_format, jodatime_format and to_char have different meanings, which will lead to query data errors. For example, mm in to_char represents the month, but in jodatime_format, MM represents the month.

Steps to reproduce the behavior (Required)

select to_char(current_date, 'yyyy-mm-dd') as aa

Expected behavior (Required)

2024-10-15

Real behavior (Required)

2024-00-15

StarRocks version (Required)

3.3.4

@LZGH LZGH added the type/bug Something isn't working label Oct 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant