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;获取随机日期文本
最新推荐文章于 2025-04-02 13:41:54 发布
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;
被折叠的 条评论
为什么被折叠?