[SPARK-8175] date/time function: from_unixtime

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Target Version/s: 1.5.0
• Sprint: Spark 1.5 release
• Assignee: Adrian Wang
• Reporter: Reynold Xin
• Created: 09/Jun/15 05:26
• Updated: 30/Jul/15 18:14
• Resolved: 30/Jul/15 18:14

Description

from_unixtime(bigint unixtime[, string format]): string

Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the format of "1970-01-01 00:00:00".

See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

Issue Links

• relates to: SPARK-8864 Date/time function and data type design
• links to: [Github] Pull Request #6984 (adrian-wang)
• links to: [Github] Pull Request #7644 (adrian-wang)