User Tools

Site Tools


Sidebar

HPL/SQL is included to Apache Hive since version 2.0

unix-timestamp

This is an old revision of the document!


A PCRE internal error occured. This might be caused by a faulty plugin

====== UNIX_TIMESTAMP Function ====== UNIX_TIMESTAMP function returns the current date and time in seconds since 1970-01-01 00:00:00. **Syntax**: <code language="sql"> UNIX_TIMESTAMP() </code> **Return Type:** INT **Example**: Get the current and date and time in seconds: <code language="sql"> UNIX_TIMESTAMP() -- 1446631617 </code> **Compatibility**: Hive. **Version:** HPL/SQL 0.3.17 See also: * [[current-date|CURRENT_DATE]] * [[current-timestamp|CURRENT_TIMESTAMP]] * [[now|NOW]] * [[sysdate|SYSDATE]]