You can’t use SYSDATE within CHECK condition. SYSDATE it is a pseudo-column function. A function is supposed to return a value and this is not how CHECK constraint was designed. With CHECK constraint you can only use explicit column values or literals. CHECK won’t do any function calls from inside. […]