Mysql database trigger

Question

I'm still new to the msyql database trigger. I would like to ask about my lines:

CREATE TRIGGER secure_dml3
BEFORE DELETE ON t_pembelian
BEGIN
 IF (SELECT TO_CHAR (SYSDATE,'DY') IN ('SUN')) OR
 (SELECT TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '09.45' AND '20.30')
    THEN
    IF DELETING THEN
    CALL RAISE_APPLICATION_ERROR (-20502,'Perubahan pada data hanya dapat dilakukan hanya pada jam kerja.');
 END IF; 
 END IF; 
END 

Mysql always says there is an error about

'BEGIN IF (SELECT TO_CHAR (SYSDATE,' DY ') IN (' SUN ')) OR (SELECT TO_CHAR (SYSD' on line 3.

I really need your help. Thanks you

Answer 1

I think you confuse the oracle with MySql. MySql does not exist TO_CHARyou can useDATE_FORMAT(SYSDATE,'DY')