Oracle DB Error ORA-02436 date or system variable wrongly specified in CHECK constraint

The following is the cause of this error:

An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.

Action you can take to resolve this issue: Completely specify the date constant or system variable.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related