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