云数据库 GAUSSDB-DBE_UTILITY:示例

时间:2024-11-02 18:53:09

示例

 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/centralized-devg-v2-gaussdb/devg_03_0737.html