[SPARK-8188] date/time function: from_utc_timestamp

• 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:59
• Updated: 02/Aug/15 04:47
• Resolved: 02/Aug/15 04:47

Description

from_utc_timestamp(timestamp, string timezone): timestamp

Assumes given timestamp is UTC and converts to given timezone (as of Hive 0.8.0). For example, from_utc_timestamp('1970-01-01 08:00:00','PST') returns 1970-01-01 00:00:00.

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 #7643 (adrian-wang)
• links to: [Github] Pull Request #7847 (davies)