云数据库 GAUSSDB-DBE_UTILITY:示例

时间:2024-11-02 18:51:24

示例

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
CREATE OR REPLACE PROCEDURE test_get_time1() 
AS
declare
    start_time  bigint;
    end_time  bigint;
BEGIN
    start_time:= dbe_utility.get_time ();
    pg_sleep(1);
    end_time:=dbe_utility.get_time ();
    dbe_output.print_line(end_time - start_time);	
END;
/
support.huaweicloud.com/distributed-devg-v2-gaussdb/gaussdb-12-0555.html