MySQL in a Nutshell, 2nd Edition

Name

LOCALTIMESTAMP()

Synopsis

LOCALTIMESTAMP()

This function returns the current system date in yyyy-mm-dd hh:mm:ss format. When part of a calculation, the results are in the numeric format of yyyymmddhhmmss.nnnnnn, which has placeholders for macroseconds. It’s synonymous with LOCALTIMESTAMP() and NOW(). Here is an example:

UPDATE appointments
SET end_time = LOCALTIME( )
WHERE appt_id = '8839';