Obtain the random time of the specified date (oracle function), oracle Function

Obtain the random time of the specified date (oracle function), oracle Function

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

/* The relative minimum value of the date string v_begin random date in the format of v_date 'yyyy-mm-dd', in days. The default value is the relative maximum value of the 0v_end random date, in days, default Value: 1 */create or replace function r_time (v_date in varchar2, v_begin in number: = 0, v_end in number: = 1) return dateis r_date date; begin SELECT 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 Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.