# CURRENT\_TIMESTAMP

Returns the current date and time. `NOW()` return a second precision result and `NOW(6)` returns a microsecond precision result.

## Syntax

```
CURRENT_TIMESTAMP()
NOW()
NOW(6)
CURRENT_TIMESTAMP(6)

```

## Return Type

Datetime object. The time zone will be in UTC unless the time zone has been converted. See [Setting the Time Zone](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/maintain-your-cluster/setting-the-time-zone.md) for more information.

## Examples

```sql
SELECT CURRENT_TIMESTAMP(), NOW();

```

```output

+---------------------+---------------------+
| CURRENT_TIMESTAMP() | NOW()               |
+---------------------+---------------------+
| 2015-03-03 21:50:04 | 2015-03-03 21:50:04 |
+---------------------+---------------------+

```

**Related Topics**

* [CURRENT\_TIME And CURTIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-time-and-curtime.md)
* [CURRENT\_DATE And CURDATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-date-and-curdate.md)
* [Data Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types.md)
* [TIME](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/time.md)
* [DATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/date.md)

***

Modified at: May 31, 2023

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/current-timestamp/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/current-timestamp/)

(An index of the documentation is available at /llms.txt)