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

Last modified: May 31, 2023

Was this article helpful?