write a trigger to dsiallow an employee joining between 6PM and 10 AM on weekdays : 
CREATE TABLE JOINING_DETAILS(EMPNAME VARCHAR2(20),HIREDATE DATE);


CREATE OR REPLACE TRIGGER TERW<BR>
BEFORE INSERT ON JOINING_DETAILS<BR>
FOR EACH ROW

BEGIN 

IF to_char(:NEW.HIREDATE,'HH24' )BETWEEN 18  AND 24 AND to_char(:NEW.HIREDATE,'HH24' ) BETWEEN 00  AND 10 THEN

RAISE_APPLICATION_ERROR(-20037,'NOT BETWEEN 6 PM TO 10 AM');

END IF;<BR>
END;


TRIGGER EXECUTED BUT I TRY TO INSERT VALUE FOR TIMING 20 IT INSERT INTO JOINING_DETAILS TABLE.....

INSERT INTO JOINING_DETAILS VALUES('PANDI',TO_DATE('20','HH24') );


HOW CAN I OVERCOME THIS....

