Gets the random time of the specified date (Oracle function)

Original Address--http://blog.csdn.net/qq525099302/article/details/47146067

/*v_date ' yyyy-mm-dd ' format date string v_begin the relative minimum of a random date, in days, default 0v_end random date relative maximum, in days, default 1*/ Create or replace function r_time (v_date  in varchar2, V_begin  in Number: = 0, v_end   in Number: = 1) return date is R_da Te date ; beginSELECT to_date (v_date,' Yyyy-mm-dd ') + dbms_random. VALUE (V_begin, V_end) Into R_date  from dual;    return r_date; end r_time;

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Gets the random time of the specified date (Oracle function)