SQL Tutorial SQL Advanced SQL Database SQL References

MySQL SYSDATE() Function



The MySQL SYSDATE() function returns the current date and time. It returns the current date and time in the following format:

  • Returns the current date and time as a 'YYYY-MM-DD HH:MM:SS' format, if used in a string context.
  • Returns the current date and time as a YYYYMMDDHHMMSS format, if used in a numeric context.

Syntax

SYSDATE()

Parameters

No parameter is required.

Return Value

Returns the current date and time.

Example 1:

The example below shows the usage of SYSDATE() function.

mysql> SELECT SYSDATE();
Result: '2021-12-27 05:11:57'

mysql> SELECT SYSDATE() + 0;
Result: 20211227051157

mysql> SELECT SYSDATE() + 1;
Result: 20211227051158

Example 2:

Consider a database table called EmployeeLogin with the following records:

EmpIDNameLogin Stamp
1John2019-10-25 09:20:38
2Marry2019-10-25 09:21:05
3Jo2019-10-25 09:24:35
4Kim2019-10-25 09:25:24
5Ramesh2019-10-25 09:27:16

To insert a new record in this table, the following query can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', SYSDATE());

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to:

EmpIDNameLogin Stamp
1John2019-10-25 09:20:38
2Marry2019-10-25 09:21:05
3Jo2019-10-25 09:24:35
4Kim2019-10-25 09:25:24
5Ramesh2019-10-25 09:27:16
6Suresh2019-10-25 09:28:19

❮ MySQL Functions

5