The GET_TIME function returns the current time in hundredths of a second (0.01 seconds).
The GET_TIME function is primarily used to determine the elapsed time. It is called twice, once at the start and once at the end of a process, and the elapsed time is calculated by subtracting the first (earlier) value from the second (later) value.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_UTILITY.GET_TIME
RETURN NUMBER;
Return value
The time elapsed since the subroutine was called, measured in hundredths of a second (0.01 seconds).
Considerations
The return value is a number in the range from -2147483648 to 2147483647. When determining the interval, the application must consider the sign of the number. For example, in the case of two negative numbers, the application logic must allow the first (earlier) number to be greater than the second (later) number, which is close to zero. Similarly, the application should also allow the first (earlier) number to be negative while the second (later) number is positive.