Apache Hive : HPL/SQL - 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.

See also:

• CURRENT_DATE
• CURRENT_TIMESTAMP
• FROM_UNIXTIME
• UNIX_TIMESTAMP
• SYSDATE