[ https://issues.apache.org/jira/browse/HIVE-18358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16308920#comment-16308920 ]
Andrew Sherman commented on HIVE-18358: --------------------------------------- The code that deals with YYYY is just [SimpleDateFormat|https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html]. I think YYYY is not the same as yyyy. It has a special meaning as 'week in year'. [https://stackoverflow.com/questions/15916958/simpledateformat-producing-wrong-date-time-when-parsing-yyyy-mm-dd-hhmm] > 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 > Labels: timezone > > 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)