[
https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Rátkai updated HIVE-28483:
---------------------------------
Summary: String date cast giving wrong result (was: last_day function
giving wrong result)
> String date cast giving wrong result
> ------------------------------------
>
> Key: HIVE-28483
> URL: https://issues.apache.org/jira/browse/HIVE-28483
> Project: Hive
> Issue Type: Bug
> Reporter: Zoltán Rátkai
> Assignee: Zoltán Rátkai
> Priority: Minor
>
> Date conversation gives wrong result. Like:1 row selected (6.403 seconds)
> select to_date('03-08-2024');
> Result:
> +-------------+
> | _c0 |
> +-------------+
> | 0003-08-20 |
> +-------------+
> or:
> select to_date(last_day(add_months(last_day('03-08-2024'), -1))) ;
> Result:
> +-------------+
> | _c0 |
> +-------------+
> |0003-07-31 |
> +-------------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
