SQL SYSDATE Function

SQL > SQL Date Functions > Sysdate Function

The SYSDATE function is used to retrieve the current database system time in Oracle and MySQL. A common use of SYSDATE is to get today's date.

Syntax in Oracle

The syntax of SYSDATE in Oracle is simply,

SYSDATE

It does not require any argument.

Example in Oracle

The SQL statement,

SELECT SYSDATE FROM DUAL;

produces the following result when run on January 16, 2000.

SYSDATE

16-JAN-2000

Syntax in MySQL

The syntax of SYSDATE in MySQL is simply,

SYSDATE( )

It does not require an argument.

Example in MySQL

The SQL statement,

SELECT SYSDATE( );

produces the following result when run on January 16, 2000, at 09:06:22 AM.

SYSDATE

2000-01-16 09:06:22

The SQL Server equivalent of SYSDATE is GETDATE.

List of SQL Date Functions

Function Name	Description
DATEADD	Adds an interval to a date value in SQL Server.
DATEDIFF	Calculates the difference between two dates in MySQL and SQL Server.
DATEPART	Extracts a specific part of a date/time value in SQL Server.
GETDATE	Retrieves database time in SQL Server.
SYSDATE	Retrieves database time in Oracle and MySQL.
EXTRACT	Retrieves a certain component of a date or timestamp value.

Next: SQL EXTRACT Function

This page was last updated on October 12, 2024.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.