HPL/SQL is included to Apache Hive since version 2.0
Sidebar
current-timestamp
This is an old revision of the document!
A PCRE internal error occured. This might be caused by a faulty plugin
====== CURRENT_TIMESTAMP Function ====== CURRENT_TIMESTAMP function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds). **Syntax**: <code language="sql"> CURRENT_TIMESTAMP | CURRENT TIMESTAMP [(precision)] </code> **Parameters:** | **Parameter** | **Value** | **Description** || | //precision// | Variable or expression | Fractional seconds precision, from 0 to 3 | Default 3 | **Return Type:** TIMESTAMP **Example**: Get the current and date and time without fraction: <code language="sql"> CURRENT_TIMESTAMP(0) -- 2015-03-02 13:04:42 </code> **Compatibility**: Oracle, IBM DB2, Teradata, MySQL. **Version:** HPL/SQL 0.1 See also: * [[current-date|CURRENT_DATE]] * [[now|NOW]] * [[sysdate|SYSDATE]]
Page Tools
