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)
