====== CURRENT_TIMESTAMP Function ======

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

**Syntax**:

<code language="sql">
CURRENT_TIMESTAMP | CURRENT TIMESTAMP [(precision)] 
</code>

**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:

<code language="sql">
CURRENT_TIMESTAMP(0)
--
2015-03-02 13:04:42
</code> 

**Compatibility**: Oracle, IBM DB2, Teradata, MySQL.

**Version:** HPL/SQL 0.1

See also:

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