SYSDATE returns the current date and time set for the operating system on which the database server resides. The data type of the returned value is DATE, and the format returned depends on the value of the NLS_DATE_FORMAT initialization parameter.
This tutorial shows you how to use Oracle SYSDATE function to get the current date and time of the operating system where the Oracle Database resides.
The SYSDATE () function returns the current date and time. Note: The date and time is returned as "YYYY-MM-DD HH:MM:SS" (string) or as YYYYMMDDHHMMSS (numeric). Return the current date and time + 1:
SYSDATE returns the current date and time from the operating system of the database server. Its data type is DATE, which stores year, month, day, hour, minute, and second - no fractional seconds. The result is “as seen by the database host,” not your client machine.
This Oracle tutorial explains how to use the Oracle / PLSQL SYSDATE function with syntax and examples. The Oracle / PLSQL SYSDATE function returns the current system date and time on your local database.
In Oracle, SYSDATE returns the system’s current date and time. To retrieve only the date: To display both date and time in a specific format, use the TO_CHAR function: This formats the output as, for example, "2025-07-24 09:22:00".
The MySQL SYSDATE () function is used to get the current date and time value. The resultant value is a string or a numerical value based on the context and, the value returned will be in the 'YYYY-MM-DD hh:mm:ss' or YYYYMMDDhhmmss format.
Summary: in this tutorial, you will learn about the MySQL SYSDATE() function and its caveat. The SYSDATE() function returns the current date and time at which it is executed. If you use the function in the string context, the return value in the 'YYYY-MM-DD HH:MM:SS' format.