[jira] [Created] (HIVE-18358) from_unixtime returns wrong year for Dec 31 timestamps with format 'YYYY'

[Nick Orka (JIRA)]

Nick Orka created HIVE-18358:
--------------------------------

             Summary: from_unixtime returns wrong year for Dec 31 timestamps 
with format 'YYYY'
                 Key: HIVE-18358
                 URL: https://issues.apache.org/jira/browse/HIVE-18358
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.0
         Environment: AWS EMR with Hive 2.1.0-amzn-0
            Reporter: Nick Orka


If you use capital Ys as a year format in from_unixtime() it returns next year 
for Dec 31 only. All other days work as intended.

Here is reproduction code:

{code:sql}
hive> select from_unixtime(1514754599, 'YYYY-MM-dd HH-mm-ss'), 
from_unixtime(1514754599, 'yyyy-MM-dd HH-mm-ss');
OK
2018-12-31 21-09-59     2017-12-31 21-09-59
Time taken: 0.025 seconds, Fetched: 1 row(s)
hive>
{code}




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)