Hive months_between(日期相减不正确处理）

Hive months_between(日期相减不正确处理）

select floor(months_between(‘2022-02-28’, ‘2022-01-28’));
OK
_c0
1
Time taken: 0.133 seconds, Fetched: 1 row(s)

select floor(months_between(‘2022-02-28’, ‘2022-01-29’));
OK
_c0
0
Time taken: 0.103 seconds, Fetched: 1 row(s)

select floor(months_between(‘2022-02-28’, ‘2022-01-30’));
OK
_c0
0
Time taken: 0.093 seconds, Fetched: 1 row(s)

select floor(months_between(‘2022-02-28’, ‘2022-01-31’));
OK
_c0
1
Time taken: 0.092 seconds, Fetched: 1 row(s)

select months_between(‘2022-02-28’, ‘2022-01-28’);
OK
_c0
1.0
Time taken: 0.115 seconds, Fetched: 1 row(s)

select months_between(‘2022-02-28’, ‘2022-01-29’);
OK
_c0
0.96774194
Time taken: 0.086 seconds, Fetched: 1 row(s)

select months_between(‘2022-02-28’, ‘2022-01-30’);
OK
_c0
0.93548387
Time taken: 0.089 seconds, Fetched: 1 row(s)

select months_between(‘2022-02-28’, ‘2022-01-31’);
OK
_c0
1.0
Time taken: 0.107 seconds, Fetched: 1 row(s)

select months_between(trunc(‘2022-02-28’,‘MM’),trunc(‘2022-01-29’,‘MM’)) ;
OK
_c0
1.0
Time taken: 0.199 seconds, Fetched: 1 row(s)

select floor(months_between(trunc(‘2022-02-28’,‘MM’),trunc(‘2022-01-29’,‘MM’)));
OK
_c0
1
Time taken: 0.154 seconds, Fetched: 1 row(s)