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
a 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

