Retrieve the current date and time.
SELECT LOCALTIME(); |
The LOCALTIME() function retrieves the current date and time.
Note: The date and time are returned either as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
LOCALTIME() |
Works in: |
From MySQL version 4.0 |
Return the current date and time plus 1.
SELECT LOCALTIME() + 1; |