pg数据库生成随机时间_postgresql随机时间戳

--function to get random number=============================================================

-- DROP FUNCTION IF EXISTS get_random_number(integer, integer);

CREATE OR REPLACE FUNCTION get_random_number(integer, integer) RETURNS integer AS

$BODY$

DECLARE

start_int ALIAS FOR $1;

end_int ALIAS FOR $2;

BEGIN

RETURN trunc(random() * (end_int-start_int + 1) + start_int);

END;

$BODY$

LANGUAGE plpgsql;

--产生1-10之间的随机数(包括边缘)

--SELECT get_random_number(1, 10);

--function for get random date between start_date and end_date

-- DROP FUNCTION IF EXISTS get_random_date(date, date);