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.

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

Bug: to_char Function Returns NULL for Valid DATE Values in DataFusion #14969

Open
kosiew opened this issue Mar 3, 2025 · 0 comments · May be fixed by #14970
Open

Bug: to_char Function Returns NULL for Valid DATE Values in DataFusion #14969

kosiew opened this issue Mar 3, 2025 · 0 comments · May be fixed by #14970
Labels
bug Something isn't working

Comments

@kosiew
Copy link
Contributor

kosiew commented Mar 3, 2025

Describe the bug

The to_char function in DataFusion returns NULL when formatting valid DATE values

To Reproduce

cargo run -p datafusion-cli -- -c "SELECT to_char(date_column, '%Y-%m-%d') FROM (VALUES (NULL), (DATE '2020-09-01')) AS t(date_column)"

+-----------------------------------------+
| to_char(t.date_column,Utf8("%Y-%m-%d")) |
+-----------------------------------------+
| NULL                                    |
| NULL                                    |
+-----------------------------------------+

Expected behavior

+-----------------------------------------+
| to_char(t.date_column,Utf8("%Y-%m-%d")) |
+-----------------------------------------+
| NULL                                    |
| 2020-09-01                              |
+-----------------------------------------+

Additional context

I discovered this bug while trying to add this slt test

SELECT to_char(date_column, '%Y-%m-%d')
FROM (VALUES 
    (DATE '2020-09-01'),
    (NULL)
) AS t(date_column);
@kosiew kosiew added the bug Something isn't working label Mar 3, 2025
@kosiew kosiew linked a pull request Mar 3, 2025 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix: to_char Function Now Correctly Handles DATE Values in DataFusion kosiew/datafusion
1 participant
@kosiew