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 DB 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   |
+------------------------------+

Was this Article Helpful?

Thanks For Your Feedback!