You are viewing an older version of this section. View current production version.

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

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