Purpose
SYSTIMESTAMP returns the current system date and time. The return value includes the time zone and the fractional seconds with 6 decimal places.
Notice
This function gets the date and time in the time zone of the operating system on which the OBServer node resides, regardless of the time zone of the current session.
Syntax
SYSTIMESTAMP
Return type
The return type is TIMESTAMP WITH TIME ZONE.
Examples
The following example returns the current system date and time including the time zone.
obclient> SELECT SYSTIMESTAMP FROM DUAL;
+-------------------------------------+
| SYSTIMESTAMP |
+-------------------------------------+
| 18-NOV-21 10.32.27.176575 AM +08:00 |
+-------------------------------------+
1 row in set