[
https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Rátkai updated HIVE-28483:
---------------------------------
Description:
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 |
+-------------+
was:
Date conversation gives wrong result. Like:
select to_date(last_day(add_months(last_day('03-08-2024'), -1))) ;
Result:
+-------------+
| _c0 |
+-------------+
| 0003-07-31 |
+-------------+
> last_day function 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)
