Name

SYSDATE( )

Synopsis

SYSDATE( )

This function returns the system date. It will return the date and time in a yyyy-mm-dd hh:mm:ss format, but will return the data in a yyyymmdd format if it’s used as part of a numeric calculation. This function is an alias for the NOW( ) function.

SELECT SYSDATE( );
+---------------------+
| SYSDATE( )           |
+---------------------+
| 2004-05-09 18:44:51 |
+---------------------+

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.