Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

NOW

Syntax

NOW()
NOW(n)

Return Type

DATETIME

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 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();

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

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

SQL

SELECT NOW() + 0;

+------------------------------+
| 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);

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

NOW

On this page