You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Kay-Uwe Moosheimer (Jira)" <ji...@apache.org> on 2025/02/01 14:10:00 UTC

[jira] [Created] (DRILL-8519) to_date returns always January

Kay-Uwe Moosheimer created DRILL-8519:
-----------------------------------------

             Summary: to_date returns always January
                 Key: DRILL-8519
                 URL: https://issues.apache.org/jira/browse/DRILL-8519
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.21.2
            Reporter: Kay-Uwe Moosheimer


Drill always returns January as the month for a select to_date(...).
select to_date('2025-02-01', 'YYYY-MM-DD') -> 2025-01-01
select to_date('2019-10-01', 'YYYY-MM-DD') -> 2019-01-01
select to_date('2020-11-28', 'YYYY-MM-DD') -> 2020-01-28

This is actually a blocker, but of course there is a workaround with cast('2020-11-28' AS date)
But it's not generally nice.
Adopted/copied queries will not deliver a correct result.

Config
Drill 1.21.2
Postgres 17.2
drill-jdbc-all-1.21.2.jar



--
This message was sent by Atlassian Jira
(v8.20.10#820010)