User Tools

Site Tools


Sidebar

HPL/SQL is included to Apache Hive since version 2.0

now

This is an old revision of the document!


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: