The GET_TIME function returns the current time in hundredths of a second (0.01 seconds).
The GET_TIME function is mainly used to determine the elapsed time. The procedure is called twice, once at the start and once at the end of a process. 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 provides only MySQL-compatible mode.
Syntax
DBMS_UTILITY.GET_TIME
RETURN NUMBER;
Return value
The time elapsed since the procedure was called, in hundredths of a second (0.01 seconds).
Considerations
The return value is a number between -2147483648 and 2147483647. Applications must consider the sign of the number when determining the elapsed time. For example, if both values are negative, the application logic must allow the first (earlier) value to be greater than the second (later) value, which is close to zero. Similarly, the application should also allow the first (earlier) value to be negative and the second (later) value to be positive.