The CURTIME() function returns the current time as a string hh:mm:ss or numerically as BIGINT hhmmss or as DECIMAL hhmmss.microseconds depending on whether the function is in string or numeric format context is used.
The value is expressed in the format of the current session time zone.
The "Precision" argument can be specified to indicate a fractional second precision from 0 to 6.
The specification of "Precision" must be a written number from 0-6. Expressions or variables produce a syntax error, larger values produce a precision error.
Setting the system variable timestamp affects the CURTIME() function. |