Reynold Xin created SPARK-8174:
----------------------------------

             Summary: unix_timestamp
                 Key: SPARK-8174
                 URL: https://issues.apache.org/jira/browse/SPARK-8174
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
            Reporter: Reynold Xin


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



--
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

Reply via email to