Home » MySQL » MySQL date/time Functions

MySQL SYSDATE() Function

MySQL | SYSDATE() Function: Learn about the SYSDATE() function, how it works, its usages, syntax, and examples.
Submitted by Apurva Mathur, on October 13, 2022

SYSDATE() Function

The SYSDATE() function is used to get the date and time both at which the function executes.

SYSDATE() Syntax

SELECT SYSDATE();

SYSDATE() Parameter(s)

The function does not accept any parameter.

SYSDATE() Return Value

This function returns us the current date and time both in YYYY-MM-DD HH:MM:SS format by default but if you add any integer/numeric value to this function then in such case it will return you the value in YYYYMMDDHHMMSS format.

MySQL SYSDATE() Function Example 1

SELECT SYSDATE();

MySQL SYSDATE() Function Example 2

SELECT SYSDATE()+9;

---