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.