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