# NOW

Returns the current date and time in the configured time zone.

## Syntax

```
NOW()
NOW(n)

```

## Return Type

Datetime object.

## Arguments

* n: specifies fractional seconds precision in the returned DATETIME value

## Remarks

`NOW()` returns a datetime object. The value is displayed in “YYYY-MM-DD HH:MM:DD” (string) or “YYYYMMDDHHMMSS.uuuuuu” (numeric) format.

**Fractional Seconds Precision**

SingleStore Helios supports DATETIME type only with precision `0` and `6`.

## Example

The following `NOW()` function returns date and time in “YYYY-MM-DD HH:MM:DD” format.

```sql
SELECT NOW();

```

```output

+------------------------------+
| NOW()                        |
+------------------------------+
| 2019-03-14 10:08:55          |
+------------------------------+

```

The following `NOW()` function returns date and time in “YYYYMMDDHHMMSS.uuuuuu” format.

```sql
SELECT NOW() + 0;

```

```output

+------------------------------+
| NOW() + 0                    |
+------------------------------+
| 20190316154840               |
+------------------------------+

```

The following `NOW()` function returns date and time value to the sixth fractional second precision in the “YYYY-MM-DD HH:MM:DD.uuuuuu” format.

```sql
SELECT NOW(6);

```

```output

+------------------------------+
| NOW(6)                       |
+------------------------------+
| 2019-03-19 09:54:05.915686   |
+------------------------------+

```

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/now/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/now/)

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