All Products
Search
Document Center

SYSTIMESTAMP

Last Updated: Jun 18, 2021

The SYSTIMESTAMP function returns the current date of the system. The return value contains the information about the current time zone. The fractional part of seconds in the return value consists of six digits and the six digits specify the precision.

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

SYSTIMESTAMP

Parameter

None

Return type

TIMESTAMP WITH TIME ZONE data type

Examples

Execute the following statement:

SELECT SYSTIMESTAMP FROM DUAL;

The following query result is returned:

+------------------------------------+
| SYSTIMESTAMP                       |
+------------------------------------+
| 2020-03-08 20:47:08.254086 +08:00  |
+------------------------------------+