Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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