Sidebar

HPL/SQL is included to Apache Hive since version 2.0

now

NOW Function

NOW function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds).

Syntax:

NOW()

Return Type:

TIMESTAMP

Example:

Get the current and date and time:

NOW()
--
2015-11-02 07:59:25.833

Compatibility: PostgreSQL and MySQL.

Version: HPL/SQL 0.3.17

See also: