All Products
Search
Document Center

SYSDATE

Last Updated: Jun 18, 2021

The SYSDATE function returns the current date and time.

Notice

This function is not dependent on the time zone of the current session but on the time zone of the Linux operating system that runs on the database host.

Syntax

SYSDATE

Parameters

None

Return type

DATE data type

Examples

In the following example, the current time is returned in the specified format:

SELECT TO_CHAR
(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
FROM DUAL;

The following query result is returned:

+---------------------+
| NOW                 |
+---------------------+
| 03-08-2020 20:44:04 |
+---------------------+