User Tools

Site Tools

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

Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

current-timestamp

====== 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]] * [[from-unixtime|FROM_UNIXTIME]] * [[now|NOW]] * [[sysdate|SYSDATE]] * [[unix-timestamp|UNIX_TIMESTAMP]]