[
https://issues.apache.org/jira/browse/DRILL-8519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Charles Givre resolved DRILL-8519.
----------------------------------
Resolution: Not A Problem
> 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
> Priority: Critical
>
> 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)
