常见Oracle日期处理问题
发布时间:2020-12-12 15:36:36 所属栏目:百科 来源:网络整理
导读:How to know what date it is today SELECT TO_CHAR(SYSDATE, 'D' ) INTO W_D FROM DUAL; or SELECT TO_CHAR(SYSDATE, 'DAY' ) INTO W_D FROM DUAL; 1 means Sunday 7 means Saturday How to get Weekends from a period of time. DROP TABLE WEEKEND; CREAT
SELECT TO_CHAR(SYSDATE,'D') INTO W_D FROM DUAL;
or
SELECT TO_CHAR(SYSDATE,'DAY') INTO W_D FROM DUAL;
1 means Sunday
DROP TABLE WEEKEND;
CREATE TABLE WEEKEND (WEEK_END DATE);
DECLARE
W DATE := TO_DATE('2016-12-01','YYYY-MM-DD');
W_D CHAR;
BEGIN LOOP SELECT TO_CHAR(W,'D') INTO W_D FROM DUAL;
IF W_D = 1 OR W_D = 7 THEN
INSERT INTO WEEKEND VALUES (W);
END IF;
W := W + 1;
IF TO_CHAR(W,'YYYY-MM-DD') = '2016-12-30' THEN
EXIT;
END IF;
END LOOP;
END;
/ (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |