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 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.

SELECT NOW();

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

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

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.

SELECT NOW(6);

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