[
https://issues.apache.org/jira/browse/SPARK-16806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15400113#comment-15400113
]
Dongjoon Hyun commented on SPARK-16806:
---------------------------------------
Yep. Please use `yyyy` instead of `YYYY`.
{code}
sql("select from_unixtime(100), from_unixtime(100, 'yyyy-MM-dd HH:mm:ss')").show
{code}
> from_unixtime function gives wrong answer
> -----------------------------------------
>
> Key: SPARK-16806
> URL: https://issues.apache.org/jira/browse/SPARK-16806
> Project: Spark
> Issue Type: Bug
> Affects Versions: 2.0.0
> Reporter: Dong Jiang
>
> The following is from 2.0, for the same epoch, the function with format
> argument generates a different result for the year.
> spark-sql> select from_unixtime(100), from_unixtime(100, 'YYYY-MM-dd
> HH:mm:ss');
> 1969-12-31 19:01:40 1970-12-31 19:01:40
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
