smallkes
2012-7-19 11:28 PM
CREATE OR REPLACE TRIGGER Guest_Change_In_WorkingHour
BEFORE INSERT OR UPDATE OR DELETE ON guest
BEGIN
IF TO_NUMBER(TO_CHAR(SYSDATE,'hh24')) < 8 -- cant do anything before 8:00am
OR TO_NUMBER(TO_CHAR(SYSDATE,'hh24')) >= 5
-- changes must be made BEFORE 5:00pm
OR TO_CHAR(SYSDATE,'dy') in ('sun','sat') THEN -- nothing on weekends
RAISE_APPLICATION_ERROR (-20000, 'Satff changes only allowed during business hours.');
END IF;
END;
/
这个是在8AM 到 5PM 才能 insert， update 和 delete 。
我的问题是 4.00pm 能insert 但是 时间变成AM 时 （4.00am），也能insert。
这个trigger ignore 掉 AM 和 PM。 谁能帮我解决？？感激不尽～
BEFORE INSERT OR UPDATE OR DELETE ON guest
BEGIN
IF TO_NUMBER(TO_CHAR(SYSDATE,'hh24')) < 8 -- cant do anything before 8:00am
OR TO_NUMBER(TO_CHAR(SYSDATE,'hh24')) >= 5
-- changes must be made BEFORE 5:00pm
OR TO_CHAR(SYSDATE,'dy') in ('sun','sat') THEN -- nothing on weekends
RAISE_APPLICATION_ERROR (-20000, 'Satff changes only allowed during business hours.');
END IF;
END;
/
这个是在8AM 到 5PM 才能 insert， update 和 delete 。
我的问题是 4.00pm 能insert 但是 时间变成AM 时 （4.00am），也能insert。
这个trigger ignore 掉 AM 和 PM。 谁能帮我解决？？感激不尽～
