MySQL in a Nutshell, 2nd Edition

Name

LOCALTIME()

Synopsis

LOCALTIME()

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. The parentheses are not required. It’s available as of version 4.0.6 of MySQL and is synonymous with LOCALTIMESTAMP() and NOW(). Here is an example:

SELECT LOCALTIME( ) AS 'Local Time', 
LOCALTIME( ) + 0 AS 'Local Time as Numeric';

+---------------------+-----------------------+
| Local Time          | Local Time as Numeric |
+---------------------+-----------------------+
| 2007-03-15 01:53:16 | 20070315015316.000000 | 
+---------------------+-----------------------+