NOW
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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.YYYY-MM-DD HH:MM:DD
(string) or YYYYMMDDHHMMSS.
(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.
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.
format.
SELECT NOW(6);
+------------------------------+
| NOW(6) |
+------------------------------+
| 2019-03-19 09:54:05.915686 |
+------------------------------+
Last modified: May 31, 2023