The SYSDATE function is used to retrieve the current database system time in Oracle and MySQL.

Oracle:

The syntax of SYSDATE in Oracle is simply

SYSDATE

It does not require any argument.

Example: The SQL statement

SELECT SYSDATE FROM DUAL;

yields the following result:

'16-JAN-2000'

MySQL:

The syntax of SYSDATE in MySQL is simply

SYSDATE( )

It does not require any argument.

Example: The SQL statement

SELECT SYSDATE( );

yields the following result:

'2000-01-16 09:06:22'

The SQL Server equivalent of SYSDATE is GETDATE.