pg数据库生成随机时间_pg函数-根据日期随机生成时间组合成完整的datetime

create or replace function gen_timestamp(_date date)

returns timestamp as

$$

declare_result text;

begin

_result:=to_char(now(),'yyyy-mm-dd')||'

'||lpad((gen_inverval_num(0,23))::int::text, 2,

'0')||':'||lpad((gen_inverval_num(0,59))::int::text, 2,

'0')||':'||lpad((gen_inverval_num(0,59))::int::text, 2, '0');

RETURN to_timestamp(_result, 'yyyy-mm-dd hh24:mi:ss');

end

$$

language plpgsql;

--调用1

select

gen_timestamp(to_date('2018-03-08 18:55:33','yyyy-MM-dd

hh24:mi:ss'))

--调用2

select gen_timestamp(CURRENT_DATE)