top of page
MySQL:
NOW
Syntax:
NOW([fsp])
Returns the current date and time as a value in 'YYYY-MM-DD hh:mm:ss'
or YYYYMMDDhhmmss format, depending on whether the function is used in
string or numeric context. The value is expressed in the session time
zone.
If the fsp argument is given to specify a fractional seconds precision
from 0 to 6, the return value includes a fractional seconds part of
that many digits.
URL: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
Example
mysql> SELECT NOW();
-> '2007-12-15 23:50:26'
mysql> SELECT NOW() + 0;
-> 20071215235026.000000
bottom of page