SQL > SQL Date Functions > 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

SELECT SYSDATE FROM DUAL;

Result:

SYSDATE
16-JAN-2000

MySQL:

The syntax of SYSDATE in MySQL is simply

SYSDATE( )

It does not require any argument.

Example

SELECT SYSDATE( );

Result:

SYSDATE
2000-01-16 09:06:22

The SQL Server equivalent of SYSDATE is GETDATE.

Next: Data Definition Language (DDL)




Copyright © 2014   1keydata.com   All Rights Reserved.     Privacy Policy     About   Contact