SELECT TO_CHAR(TO_DATE('01/01/15','mm/dd/yy'),'J')FROM DUAL;
SELECT TO_CHAR(TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2457024,2457024+364)),'J'), 'yyyymmdd') FROM DUAL;
获取随机日期文本
最新推荐文章于 2024-02-03 21:21:18 发布
SELECT TO_CHAR(TO_DATE('01/01/15','mm/dd/yy'),'J')FROM DUAL;
SELECT TO_CHAR(TO_DATE(TRUNC(DBMS_RANDOM.VALUE(2457024,2457024+364)),'J'), 'yyyymmdd') FROM DUAL;