SQL SYSDATE Function

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.

Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.

<a href="http://www.1keydata.com/sql/sql-sysdate.html">SQL SYSDATE Function</a>