Loading lesson path
Concept visual
Start at both ends
Return the current date and time:
SELECT CURRENT_TIMESTAMP();The CURRENT_TIMESTAMP() function returns the current date and time.
Formula
The date and time is returned as "YYYY - MM - DD HH - MM - SS"(string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
CURRENT_TIMESTAMP()
From MySQL 4.0
Formula
Return the current date and time + 1:SELECT CURRENT_TIMESTAMP() + 1;❮ MySQL Functions