HPL/SQL is included to Apache Hive since version 2.0
Sidebar
current-timestamp
CURRENT_TIMESTAMP Function
CURRENT_TIMESTAMP function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds).
Syntax:
CURRENT_TIMESTAMP | CURRENT TIMESTAMP [(precision)]
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:
CURRENT_TIMESTAMP(0) -- 2015-03-02 13:04:42
Compatibility: Oracle, IBM DB2, Teradata, MySQL.
Version: HPL/SQL 0.1
See also:
Page Tools
