[SPARK-8174] date/time function: unix_timestamp

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• 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:25
• Updated: 30/Jul/15 18:14
• Resolved: 30/Jul/15 18:14

Description

3 variants:

unix_timestamp(): long
Gets current Unix timestamp in seconds.

unix_timestamp(string|date): long
Converts time string in format yyyy-MM-dd HH:mm:ss to Unix timestamp (in seconds), using the default timezone and the default locale, return 0 if fail: unix_timestamp('2009-03-20 11:30:01') = 1237573801


unix_timestamp(string date, string pattern): long
Convert time string with given pattern (see [http://docs.oracle.com/javase/tutorial/i18n/format/simpleDateFormat.html]) to Unix time stamp (in seconds), return 0 if fail: unix_timestamp('2009-03-20', 'yyyy-MM-dd') = 1237532400.

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

Issue Links

• is duplicated by: SPARK-9374 unix_timestamp throws AnalysisException
• 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)