Gabor Kaszab created HIVE-22511:
-----------------------------------
Summary: Fix case of Month token in datetime to string conversion
Key: HIVE-22511
URL: https://issues.apache.org/jira/browse/HIVE-22511
Project: Hive
Issue Type: Bug
Reporter: Gabor Kaszab
Currently Hive doesn't allow month tokens with weird spelling like 'MONth',
'mONTH' etc. However, Oracle does and Hive should follow that approach.
The rules:
- If the first letter is lowercase then the output is lowercase: 'mONTH' ->
'may'
- If the first two letters are uppercase then the output is uppercase: 'MOnth'
-> 'MAY'
- If the first letter is uppercase and the second is lowercase then the output
is capitalized: 'Month' -> 'May'.
Oracle:
{code:java}
select to_char(to_timestamp('2019-05-10', 'YYYY-MM-DD'), 'MOnthYYYY') from DUAL;
MAY 2019
select to_char(to_timestamp('2019-05-10', 'YYYY-MM-DD'), 'mONTHYYYY') from DUAL;
may 2019
select to_char(to_timestamp('2019-05-10', 'YYYY-MM-DD'), 'MoNTHYYYY') from DUAL;
May 2019
{code}
Please check the same for 'Name of the day' tokens.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
