====== NOW Function ======

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

**Syntax**:

<code language="sql">
NOW()
</code>

**Return Type:**

TIMESTAMP

**Example**:

Get the current and date and time:

<code language="sql">
NOW()
--
2015-11-02 07:59:25.833
</code> 

**Compatibility**: PostgreSQL and MySQL.

**Version:** HPL/SQL 0.3.17

See also:

  * [[current-date|CURRENT_DATE]]
  * [[current-timestamp|CURRENT_TIMESTAMP]]
  * [[from-unixtime|FROM_UNIXTIME]]
  * [[unix-timestamp|UNIX_TIMESTAMP]]
  * [[sysdate|SYSDATE]]