SYSDATE

Retrieve the current date and time.

SELECT SYSDATE();

Definition and Usage

The SYSDATE() function retrieves the current date and time.

Note: The SYSDATE() function returns the current date and time in the format “YYYY-MM-DD HH:MM” (string) or YYYYMMDDHHMMSS (numeric).

SYSDATE()

Works in:

From MySQL version 4.0

Retrieve the current date and time, incremented by 1 unit.

SELECT SYSDATE() + 1;