Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the current date and time in the configured time zone.
NOW()
NOW(n)
Datetime object.
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
.
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 |
+------------------------------+