Skip to main content

SingleStoreDB v8.0

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

SingleStoreDB 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   |
+------------------------------+
In this section: