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 |
+------------------------------------+